I love Supernatural's extensive use of classic rock, it's so fun. (Especially in the first 5 seasons when the show was at its best, IMO.) The one that sticks out in my mind is when they use Renegade by Styx. (Honestly, I'm surprised that they never used Free Bird.)
I'm more into new wave music, but there really is an itch that can only be scratched by rock, especially for use in TV shows/movies. (Though iZombie's use of Der Komissar is a great use of new wave.)
Let's add to the queue:
Kickstart My Heart by Motley Crue
And to be thematic because why not...
Running With The Devil - Van Halen
Werewolves of London - Warran Zevon
November Rain - Guns N Roses