I can see that I'm in the minority here, as I tend to play rock music in the background of sessions I run. Why? Cuz I like it? For me, it works, but YMMV. Whenever I listen to Dinosaur Jr. I still think of Dark Sun though...
However, even if you aren't interested in the rocknroll DnD idea (but you'd be missing out, hehe) EVERYONE EVERYWHERE should check out anything by Cradle of Filth. You will die, one way or the other. The best approximation I can give is this:
Imagine Mozart, Ozzy Osbourne, Satan and Demogorgan getting absolutely wacked on speed and acid and gettin' it on, then having kids. The first, of course, would be Tenacious D, but the second would be Cradle of Filth
I can't say that I would ever use this in a game (as the players would all implode from shock/laughter/horror) but it's good (?) to know that ts out there.
Amos