I have to chime in and say that I love the music in Twisted Metal: Black, especially Vesti la Giuppa. There’s something absolutely charming about listening to opera while blowing shit up.
There is a song on the .Hack games for the PlayStation 2 that I liked. Legend Of Zelda: Windwaker had a good intro theme song. Also, speaking of Twisted Metal, Twisted Metal 4 had a Rob Zombie song that I liked.