Depends on what you call good, as I listen to a lot of musical variety. Here's a few I haven't seen yet:

The Needle and the Damage Done - Neil Young.

A Short Term Effect - the Cure (to name the most blatant one...)

Drugs - Roxy Music (I think, I mostly know covers - Eno and Ferry wrote it)

Rocket Man - Elton John

Space Oddity - David Bowie (if too vague, Ashes to Ashes verifies - ashes to ashes, funk to funky, we all know Major Tom's a junkie - strung out in heaven's high, hitting an all time low).