I'm late on the thread, but I would offer up The Purrs' "She Got
Chemicals" as one of the best drug songs.    I tried to find some
video or audio, and the closes I can provide is to point you to their
CD Baby site:  http://cdbaby.com/cd/purrs3

Those guys are awesome live.  Very druggy, in a The Verve kind of way.

Gary
See a new Shake Some Action! video:
http://www.youtube.com/watch?v=KTHiAoDuoYw