Hmmm, I would say that it's impossible. You would need to constantly churn out new content that is made based on what players do in the game, and that is just to much for any studio to handle. What I'm getting at is that in single player rpgs quests aren't (and don't need to be) re-doable, because, once you save the village elder's daughter from a gang of bandits, that's it, the daughter is saved and the bandits are dead. But what happens when the the next player comes over to that village? You can either suspend your disbelief and have the bandits magically resurrect and kidnap that same daughter in order for the quest to be available to everybody (which is what MMOs do regularly... Velan Brightoak is practically swimming in Springpaw pelts by now

) or you can advance the narrative and make a quest that, for example, is now given by the rescued daughter and has nothing to do with the already vanquished bandits. Doing the latter is insanely difficult even with minor and unimportant quests, now just imagine how bonkers it would be to try to do that with a major quest that impacts the story in a significant way.