Basically all of those types of stories have to throw game design out the window. The goals of your standard fantasy protagonist 'be the chosen one' go directly counter to what makes a successful game. Imagine if WoW had random chances for a tiny fraction of players to role some Uber OP class or skill that utterly dominated everyone else. And everyone else was just expected to keep playing to be side characters to that one guys character.