"Hero" is a single by Chad Kroeger, the lead singer of Nickelback, recorded in 2002 by Kroeger; Josey Scott, the lead singer of Saliva; Tyler Connolly, guitarist and lead singer of Theory of a Deadman; Paul Iverson - bassist of Strange Advance; Mike Kroeger, bassist of Nickelback; Matt Cameron, drummer of Pearl Jam; and Jeremy Taggart, drummer of Our Lady Peace (for the video), for Spider-Man. It is generally credited in full to "Chad Kroeger featuring Josey Scott."
Bonnie tyler has a song called hero. You hear it in movies a lot.
Mariah Carey, of all people, sings this particular song! Listen to her version!
There are two different songs called hero that I know but the one I think you are thinking about is by Mariah carey