In the late 70s, Bowie made a video featuring a mad artist ("Look Back in Anger" of the album Lodger) . More or less twenty years later, he played a mad artist, Julian Priest, in the TV series "The Hunger." It is mentioned in his first episode that Priest "dropped everything and came to New York." It could be argued that the Lodger dropped everything,came to New York, and became the scary, philosophical Julian Priest!
The Man Who Sold The World by David Bowie is great because of this. Its largely Nietzschian lyrics are already somewhat creepy but "The Supermen" is essentially about the death of god and how men are killing each other for a chance to die.
Where sad-eyed merriment tossed in slumbers
Nightmare dreams no mortal mind could hold
A man would tear his brother's flesh, a chance to die
To turn to mold.
The fate of Major Tom at the end of Space Oddity was one for many years. It takes most people a couple or more listens to realise where the song leaves him.