I like alot of Manson's older music..particularly Get Your Gunn and Lunchbox..and almost anything with the Spooky Kids. His newer stuff just isn't for me, but as a musician at least the guy does what he does. I'll respect that any day of the week.
Also, as outnumbered as the original poster is, I feel your plight. I've heard the same complaints about a number of bands that I absolutely adore(Twiztid, Slipknot, ICP, Body Count, Buckethead, hell even Iron Maiden) people just get turned off by the look of a musician and don't get to understand what that musician is all about. But, for those that have listened to Manson and can't stand him..well then more power to ya!
Its all a personal decision anyways, but still, hating something because it looks weird is just..well yeah.