They avert this trope after becoming the new Daedric Prince of Madness, losing the "Normal" part in more ways than one.
However, this does not stop them from marching into Oblivion and killing hordes of Daedra.
Apart from this, there is nothing setting them apart from other people. The only peculiarity this character has, is that they happen to be at the right place at the right time to meet the emperor and set in motion the chain of events leading to the defeat of Mehrunes Dagon. The player character from Morrowind is the Nerevarine, the reincarnation of an ancient legendary general, while the player character from Skyrim is the Dragonborn, a mortal with access to the reality warping ancient language of the dragons. Badass Normal: Comes over as this compared the player characters from Morrowind and Skyrim.more than two points), and must go on another pilgrimage to be absolved of their sins in order to wear them again. As a Knight of the Nine, the Hero will be stripped of all holy relics should they gain enough Infamy (i.e. The Atoner: You can play as one, by gaining infamy (especially with the Dark Brotherhood), then going on a pilgrimage or undertaking the Knights of the Nine DLC to remove it.Ascend to a Higher Plane of Existence: Becomes the new Daedric Prince of Madness after the events of the Shivering Isles.And, as with other skills, others in the world will comment on the Hero of Kvatch's magical talents if they are high enough. And a wide variety of magical powers can be obtained during play. The Archmage: Players in the Mage's Guild will gain the title of Archmage.Skyrim further implies that the player character canonically became Sheogorath, dropping small hints that they may also have been involved with the Dark Brotherhood questline (they mention a severed head) and Thieves Guild (they mention a fox). Anti-Hero: If played with high infamy.After assuming the mantle of Sheogorath, even Jyggalag is uncertain whether to call you mortal or god. Ambiguously Human: A normal man, mer or even Beast Man at the beginning of the game.After completing the Shivering Isles DLC, the Hero basically mantles Sheogorath, whereupon the concept of gender becomes irrelevant as Daedric Princes are technically genderless and can assume whichever form they want. Ambiguous Gender: Although most promotional materials depict them as an Imperial male, the Hero's gender (and race) is left up to the player's discretion.A God Is You: By the end of Shivering Isles.After escaping and witnessing the Emperor's assassination, they are tasked with delivering the Amulet of Kings to Jauffre. A prisoner in the Imperial Prison that was lucky enough to cross paths with Emperor Uriel Septim and the Blades.