Originally posted by Flipside
The Perfect Drug - NIN (Actually about Absinthe)
I'm going to be a pedant here but the song was actually written about his dog Daisy May. So I've read in a few different interviews anyway.

Also,
Queens of the Stone Age - Feel Good hit of the summer ("Nicotine/Valium/Vicoden/Marijuana/Ecstasy and Alcohol")
Queens of the stone age - Better Living through chemistry
**** it, all the songs off "Rated R" by QOTSA are about drugs pretty much.
Faith No More - Crack Hitler
Faith No More - Cockoo for Cacka
Ween - Put the coke on my dick
Ween - Mushroom Festival in hell
Tool - Third eye
Snake River Conspiracy - Coke and Vaseline
Clutch - Spacegrass
Kyuss - Demon Cleaner
Pretty much any Alice in Chains song.
Man, I could go on all day.