I think it fair to say that I sort of get the appeal of David Bowie, but am perhaps just a bit too young to fully get it. I think his biggest fans are those who started following him from the start, and at that time as a pre-teen I was certainly much more interested in the actual space program than in a sexually ambiguous, psychedelic tinged pop musician's introverted way of looking at it. (That really was the most annoying thing about the 60's and early 70's: just at a time the world could be celebrating and extending a stunning outreaching milestone in the history of humanity, youth culture in the nations that had achieved it went instead down the rabbit hole of sex and druggie self indulgence.)
But sure, he had many good and catchy songs and an eclectic style; and later came to make enough anti-drug comments that he was once quoted by my local parish priest! I also saw him in self-mocking mode in Zoolander just on Sunday night - the first time I have ever watched it. Yeah, he seems to have a been a pretty nice guy in his private life (once he cleaned his act up, at least), and it is sad that he's died relatively young.