My personal favorites

[PZ]

As I head into my 6th decade of life, this one is particularly poignant

http://www.youtube.com/watch?v=lrXIQQ8PeRs#ws

[Fiach]

Cool song  :-X They had a HUGE hit back in the day, buggered if I can remember the name though :(

[PZ]

Blurry was one that was quite popular - oops... actually by Puddle of Mudd
http://www.youtube.com/watch?v=xJJsoquu70o#ws

Maybe this is the one you were thinking of - Hero, one of the songs on the movie Spider Man
http://www.youtube.com/watch?v=9zueKq3z3Sk#ws

[PZ]

Another Nickelback song that is meaningful to me - reminds me of my youngest son.
http://www.youtube.com/watch?v=BB0DU4DoPP4#ws

...and these are good too
http://www.youtube.com/watch?v=1cQh1ccqu8M#ws
http://www.youtube.com/watch?v=-VMFdpdDYYA#ws
http://www.youtube.com/watch?v=1cQh1ccqu8M#ws