There are a few genres, like super heroes or secret agents, that call for a pinnacle character, but I think I mostly prefer this "ordinary person in extraordinary circumstances" trope.
It's why I like DS9 more than TNG.
For my fantasy games, I want a zero to hero experience. I like the feeling...