Yeah indeed I think that this idea is just something very general and all will depend on the way it is implemented, I totally agree with the example of spore and I think it was not very fun in that game to totally forget all the previous levels of details, it was like doing something useless before beginning the real game (space phase).
I think the main point to implement it is to allow the player to use almost (usefull word isn't it ? indeed I think maybe the biggest issue is this "almost") every action in a procedure and force him to continue playing by bringing new situation to him, it would not be very different from most of the game : new tech, war, differences between all place you can colonize, old city were all resources has been mined, ...
"maybe one day you can build such a game and see it it works "
I would like to have the time , I am totally sure it can work in several implementations I have thought about.