I'm still on my Transformers: The Movie kick.
I've never used these songs in any of my games. Yet one of the reasons why the movie is so awesome is because they combined fantastic animation featuring Transformers with 80s rock'n roll. The movie itself is pretty dark--an entire civilized planet gets destroyed in the first five minutes, lots of death an destruction--but somehow the music by Vince DiCola works.
It makes the movie epic.
I don't know how these songs would work for a D&D/Fantasy game. Definitely sci-fi. But probably not Dark Heresy--related RPGs (Although a bunch of Space Marines fending of a Necron assault to "The Touch" would be pretty damn amusing).
The Theme Song
"Instruments of Destruction"