Well, I know a few women who find Worf attractive. I guess it depends on how one feels about the Klingon look, and the opinions are split on that one. I think that Cardassian makeup is attractive; Klingon, not so much, but Worf is not bad-looking for a Klingon, and Michael Dorn is very attractive IRL.I don't mean to be shallow
Then your thread should have ended right there...
Just for fun though I'll play the game. First, you can't factor in Odo, Quark, Rom, Worf, Morn, and all the other characters in heavy latex since you can't really see the actors.
I see nothing wrong with the rest of the cast. Others have mentioned O'Brien as being ugly, well that's a matter of perspective. He has distinctive features and curly hair and doesn't look like a GQ model, but does that make him ugly? O'Brien is supposed to be the everyman; a husband and father, working with his hands and getting stuff done. Carey Grant or Clark Gable in their prime, or even George Clooney couldn't necessarily pull that off.
Odo is a shapeshifter who sucks at forming a humanoid face, so his unformed facial features are a part of his character. The Ferengis are, well, the Ferengis - not every alien race is going to look attractive according to human standards. To humans and some of the other alien races like the Bajorans, they may look like ugly little trolls, but Quark might be considered handsome among the Ferengis.
That leaves O'Brien. It's not like he's ugly, hideous or deformed, he's just an ordinary-looking guy. As Kirby said, he's supposed to be an everyman character, so Colm Meaney's look works for the character. It's refreshing to see someone on TV who looks like a normal guy, rather than a pretty boy or rugged square-jawed hunk.
If DS9 was about a bunch of genetically engineered people living in a Gattaca-like society, then it would make sense to have everyone look stereotypically pretty, like those Augments from ENT. But it's not.
which brings up another thing... Damar...most of the girls that hang out here think Casey is smokin...I don't know b/c I'm straight as an arrow and happily married at that.
Biggs has won more than his share, DS9 who's the hottest guy. There's one here (not dropping names) whom I'd bet would drop the clothing and hit the hay w/him in a NY minute.
So....there!