I'd have to say that for all his foibles, Bono deserves a mention. An incredible frontman in his day, influential, incredibly good lyricist and fronts a band that was, arguably, the worlds biggest band for a number of years.
Also, if you're going for sex appeal, this guy has it in abundance (according to the laydees);