Off the top of my head...
Duel of the Heroes - Revenge of the Sith
Comm Susser Todd - End of Evangelion
The Beginning is the End is The Beginning - Smashing Pumpkins
Through the Fire and Flames - Dragonforce
Fairwell Hyrule King - Legend of Zelda Wind Waker OST
End of the World As We Know It - R.E.M.
Requiem For a Dream - Jared Leto
Carmina Burana -
http://www.youtube.com/watch?v=LGJiTpBBD18
Mad World - Gary Jules
Gollum's Song - The Two Towers
The Krakken and Davy Jones themes from POTC: Dead Man's Chest
If it's glorious courage in the face of certain death type thing your looking for than anything from Rhapsody or Manowar.