Ok, as far as movies go, I see two different categories: Those whose heroes have powers, and those whose heroes do not.
With Powers:
Mystery Men was excellent. I especially liked the Shoveller. No powers and not a billionaire. Most realistic to rlsh circumstance. Mister Furious very complex character and shows great growth due to being part of a supportive team.
Supergirl, probably the very worst superhero movie ever made. But Helen Slater rocked the outfit!
Without powers:
Hero at Large was a great film with John Ritter. He had no powers, but an exceptional amount of courage and luck. I won't give away the plot, but it really rocks.
Kick Ass is a great book series, but since the film hasn't hit theatres yet, I reserve my opinion.
Condorman was pure awesome, and made me want to be doing this.
Jingle All the Way, with the Governator. Just kidding.
Anyone here remember the TV show Misfits of Science? Awesome show, but tragically cut short.