Your mileage may vary. As far as I am concerned, it works out for Spock, Kira, Dukat, Sarek, Ro Laren, K'Ehleyr, Picard, Data (I'd rather describe it as lovable cuteness, but many girls find him hot), Damar, and I would argue, maybe even Jadzia Dax, among others. But then anyone can disagree with both who they consider a good character, and who they find sexy. Quite a few people find Seven an interesting character.
There's a difference between an attractive character and a character designed to boost ratings with their chest. For example, Saavik was an attractive character, but she wasn't really sexy, per se.
I'm not sure why that quote is attributed to me... I never said it. That was DevilEyes. Though I more-or-less agree with the sentiment.
And I personally like Seven. Yes, she was attractive, and the design of her catsuits made things rather obvious, but I never saw her as just a sexy babe designed to boost ratings. Maybe the suits at UPN did, but I actually enjoyed the character, and Ryan's portrayal of her.