Given the subject matter I think the box art should certainly have something sensual about it, but this one rather misses the mark. I wouldn't say it's "ugly" as it's technically competent, but aesthetically, it's a no.
This doesn't say "sex and intrigue" so much as "Look! Nekkid women!"
If I had to guess I'd say the game in some way involves strippers and minigames... and top hats.
I think it's a mistake giving the wrong impression about a game just to get a sale... I know of one person that was intrigued by Max Payne 2's "noir love-story" tag-line but hugely disappointed to find that it was just another action game. Sure it was a sale, but it may have stopped her from trying other games in the future.
For an example of more or less appropriate use of sex in box art I would point to
Vampire Bloodlines... It sets a tone of "dark, gothic and sleazy" which is basically accurate, though it belies the degree of subtlety with which this seedy side of nocturnal Los Angeles is explored in-game...