There are many from the early seasons that I love, not so much from the later ones. Aside from the ones already mentioned, I love:
Bad Moon Rising during the crash sequence at the end of Devil's Trap
Back in Black at the beginning of Bloodlust (think that's the first time we hear Dean call Baby, Baby, no?)
Oh Death as Death's intro. Excellent choice there!
There are others as well, but those are the ones that come to mind right away (the first two perhaps because I'm rewatching~again and am on Season 2 :D )