TV:
Sportacus (Lazy Town) The perfect athlete, never fails at anything he tries.
Supergirl (Supergirl) Contrary to popular belief, she is not more powerful than Superman.
Movies:
Quicksilver (X-Men Days of Future Past) So fast it's scary.
Gretel (Hansel and Gretel: Witch Hunters) immune to spells, agile and skilled martial artist, medieval weapons specialist.
Comics:
Stardust (Stardust the Super Wizard) has super-strength, flight, invulnerability and any power that would be useful in a situation, and no weaknesses.
Hannah Washington (Ant) Basically Spiderman with some upgrades.
Videogames:
Genn Greymane (World of Warcraft) Insanely fast and superhumanly strong werewolf.
Lightning (Final Fantasy) Ridiculously powerful magic-warrior, little bit of a glass cannon.
Books:
Leto Atredes II (Children of Dune) a nigh Immortal Half-Human Hybrid.
Amanda Tweedle (Blonde Genius) Superintelligent, excels at everything she does.
Anime:
Kirito Kazuto (Sword Art Online) ridiculously smart, his health regen is so high that it's faster than enemies can deal out damage.
Lina Inverse (Slayers) crazy powerful mage, can draw power from the Lord of Nightmares.
Music:
Wonderboy (Tenacious D) Flight, telekinesis, and the power to move you.
Charlotte the Harlot (Iron Maiden) nearly invulnerable prostitute "Abuse her misuse her she can take all that you've got"
The Internet:
Kyle (The Young Protectors Webcomic) Fire based hero
Redd (Redd Webcomic) Born without arms or legs, she has robotic appendages for any occasion. Think Cyborg only hotter.