Zappa: excellent counter-argument, sharke.
I can think of several examples of well-adjusted but brilliant musical minds: Paul Simon, Paul McCartney, uh, mmm, help me out here...well, there's Zappa, of course. And Michael Jackson, nothing weird about him.
OK, I guess the list of those with personality disorders and substance dependencies really is longer. Starting with Ludwig van Beethoven. I've visited Vienna and it seems like every other building there has a plaque saying "Beethoven lived here" - it's because he kept getting evicted for un-neighborly behavior.