The Name of the Game by Bryan Ferry is a great song about addiction (cocaine I believe, he had a big coke addiction after Jerry Hall left him. At least that's what I think the song is about.)
Akira Yamaoka's Silent Hill compositions definitely.
Damn, forgot to mention Roxy Music's No Stange Delight.