Thanks for the posts to this thread. Reminded me of a few other really good old songs, like Codine by Donovan, Kicks by Paul Revere and the Raiders, etc....brings back memories. And, of course, Cocaine by J.J.Cale (popularized later by Clapton); Cocaine is maybe a little more ambivalent, one line "Don't forget this fact, You can't get back, cocaine" is probably the only anti-drug sentiment in the song.
Gotta love any RHCP songs, so thanks for reminders on those. Thanks for pointing out the mashup of their Otherside by Macklemore & Ryan Lewis...excellent.
Sober by Pink was the most recent hit, I think, off what was posted so far. No?
Some of the thrash metal stuff is decent stuff, but it's hard to make out the lyrics for all the metal. As such, without handy lyrics, it's a bit hard to feel what the song is about.
The country stuff was also good, and I suspect for country fans, there's probably lots of realistic drug tales in lyric, especially if you want to include alcohol addiction. Not a big country fan, but I really liked the sublime Johnny Cash cover of Hurt by Trent Reznor.
Of course, any of the Christian Rock stuff is going to be anti-drug; Believer has a newer single "Stoned" on the same theme. Again, not a big fan.
A few of the songs seemed fairly ambivalent and just characterized life with drugs, not passing judgment. Probably more effective to be real than preachy.
Any more? Anything better than Neil Young? Still the best IMHO.