In the case of Thrive, I think we have failed to introduce enough variety if a map editor is one of the most requested features.
What I envision that players could do is share saves where they may have made like a really unusable species, and the challenge is to salvage it. So far not many save files have been shared, but there’s at least Save files!
Highlight a part of the post with your mouse, that causes a “QUOTE” button to appear.
Then, I’m really interested how the Spore adventure stuff could make varied stuff? If you can just design planets and put creatures on them, that doesn’t create a narrative “adventure”, there must be some kind of custom game logic (perhaps scripting in disguise, which I basically see in that screenshot you posted). Making such a system is quite a lot of work as someone needs to program all the behaviours that you can edit with the dropdown menus etc.