Pulp- Sorted for E's and Whizz
Tenacious D- Marijuanaville
Manic Street Preachers- Methadone Pretty
Weezer- We are All on Drugs
The Verve- the Drugs Don't Work
Manics- Drug Drug Druggy
Weezer- Hash Pipe
50% of all Beatles content between 1965-1968.
"Bad" by U2 about heroin abuse in Dublin.
Much of "Screamadelica" by Primal Scream about ecstasy culture.
For song titles there's always "Lost In The K-Hole" and "Under The Influence" by the Chemical Brothers.
A lot of periods in music history have certain drugs associated with them so records around 1967, 1988, maybe around 1997 will make some kind of reference to drugs.
100% of Velvet Underground content from whenever (esp Heroin).
Another Girl, Another Planet is supposed to be about junk too.
Smack My Bitch Up
Itchycoo Park
Chinese Rocks (Johnny Thunders)
Now I Wanna Sniff Some Glue (Ramones)
Pills (New York Dolls)