What is the real purpose of creation ?

Which creation specifically? The spiritual or the physical? The physical creation, i.e. the heavens (universe) and earth were created for man, who was to fill and subdue it.

Isn't that a question for its Creator, rather?

To sing little "thank you's" to the creator

nothing is created

To Exist.

To live

* Deriving satisfaction

Honestly just for the experience of it, I don't think there's a greater meaning to everything. We're here to be happy and make every other person we meet as happy as possible.