Just like LBP, it will take time for people to create incredible experiences. I reckon we'll see a lot of music, art and animations to begin with. There will be many environments to walk around and rudimentary games to start with. I just hope they've got a good search tool.
I really hope they manage to implement VR somehow...this would be simply incredible. Literally creating dreams!