Hi sandbox,
Good thread! How about "Mr. Brownstone" by Guns n Roses, "There She Goes" by the La's, "Dead Flowers", Rolling Stones. Others that come to mind are "Golden Brown" by the Stranglers, "Heroin, She Said" by Wolfsheim, "The Needle and the Damage Done" Neil Young and Velvet Undergrounds "Heroin"
Hope these have been of some help.
Best Wishes
Northsider