I was just thinking about it there but I found the heroes of Skyrim and Morrowind quite boring for a couple of reasons, the hero of Morrowind is the reincarnation of the Dark Elf hero of legend while the Skyrim hero is the mortal with dragon blood. Both of them are born great and didn't have to do much to get their titles.

The hero of Kvatch however I think is a good hero. (S)he didn't start out as anything other than a mortal but he did save a lot of towns and then all of Tamriel from Oblivion. He does however become Sheogoroth but other than that he again did this as a mortal with no more help than any other being. To me the Seventh Champion of Cyrodiil is a good character.

Kind of pointless, because there is no cannonocal character, they are all blanks, and dependeable on player, so saying who is favorite, also wasn't there implied somewhere that all Tamriel heros are born as Shezzarines champions of mankind? Because if so then there goes the theory that he wasn't born special, hell the only character who was born special is Dovahkiin, Morrowind hero wasn't born Nerevarine this is not how prophecys work in TESverse
Eternal champion normal guy
Agent of Blades normal guy
Nerevarine normal guy who mantles prophecy
Hero of Kvatch normal guy who later mantles sheogorath
DragonBorn guy who was born with soul of dragon