But why would you? Nothin’ about drugs in that song.
Lord I’m Discouraged by Hold Steady. Very sad and tragic.
The sutures and bruises are none of my business
She says that she’s sick, but she won’t get specific
The sutures and bruises are none of my business
This guy from the north side comes down to visit
His visits, they only take five or six minutes
Happy to contribute to a fine zombie topic.
The two that come to mind:
K’s Choice - I’m Not an Addict. Told from the point of view of someone in complete denial. A one-hit band from Belgium; it sticks in my head as a great pop song, but the underlying meaning just kills me.
Concrete Blonde - Joey. Hearing Johnette Napolitano sing her guts out to get her substance-abusing boyfriend to come home when he’s probablly passed out somewhere on the floor also just kills me.
Alice in Chains - Angry Chair
It’s basically describing going through Heroin withdrawal, And I actually lived with a heroin addict and one time this song came on the radio and he slammed the off button, he just couldn’t take listening to it.
“Loneliness is not a phase
Field of pain is where I graze
Serenity is far away”
The guy knew what he was talking about he destroyed himself on the stuff.
Now she puts the kid away,
and she’s gone to get a hit
She hates her life,
and what she’s done to it
There’s one more kid
that will never go to school
Never get to fall in love,
never get to be cool.
Keep on rockin’ in the free world.
“Cocaine’s for horses, not for men.
They say it’ll kill me, but they won’t say when.”
– Cocaine Blues
How about The Who’s anti-tobacco jingle “Little Billy”?
Ozzy’s Suicide Solution is the gold standard as far as I’m concerned.
Wine is fine, but whiskey’s quicker
Suicide is slow with liqueur
Take a bottle, drown your sorrows
Then it floods away tomorrows
Well, since we’re resurrecting a thread from before she even staked her claim to fame, I guess this is as good a place as any to nominate Amy Winehouse’s “Rehab” as an ironic anti-drug anthem, in how it encapsulates her refusal to get help until it was too late.
This is where I get to be a pedant and mention that Ozzy apparently has Parkin Syndrome (similar to Parkinson’s Disease), and that his tremors aren’t due to drug use over the years.
Zombie or no, I would like to make a correction.
My quotation was from the Dandy Warhols, not the Dead Kennedies.
The song is called Not if You Were the Last Junkie on Earth.
I would also like to mention Monkey on Your Back by Aldo Nova.
When I read the OP title, I didn’t even think of lyrics. The best anti-drug messages in rock were the corpses of so many great rock stars lying dead on the floor from ODs or other drug related deaths like choking on their own vomit.
I think the best anti-drug song ever may be Amy Winehouse’s ‘Rehab’, because it’s a long justification for why she doesn’t want to go to rehab for her drug and alcohol habits - and then she died.
Now every time I hear that song it just sounds like the last thing you generally hear from people before the drugs get them.
How about a rap song? Not a single, but an album track from Sir Mix-a-lot, “I’m Your New God”:
girl weeping
WHAT’S WRONG, SWEETHEART?
DON’T YOU WANT ME?
YOU PAID FOR ME. KNEEL TO ME.
rhythmic sniffing
SMOKE ME. BREATHE ME. INHALE …
HA HA HA HA HA HA, I’M YOUR NEW GOD.
She’s only 16, she looks lost
Bought crack from the dopeman, and got tossed
Livin on the streets, smoked out
Perfect individual for me to bust out
You can sniff me, or you can puff me
But the girl shoulda known, you can’t trust me
She’s only 98 pounds and lonely
She calls to her God for help, and that’s me
COCAINE, go ahead n’ use me, heh heh
Momma won’t know you’re a junkie
Just put me in your pipe, light and SUCK
deep inhale Cluck cluck cluck!
Thanks, Exapno. I remember that one from 1966, but didn’t know who performed it. 
Pink Floyd’s “Comfortably Numb” could be seen as a critique of how the music industry forces performers into using drugs to keep them on stage.