Obviously all this sex couldn't possibly be good 100% of the time, and
it wasn't. Aphrodite was as well known for the pain she brought as she
was for the pleasures of sexual passion which she personified. The
lesson she taught was: "Every pleasure has its price."

The most notorious example of this is when she promised Paris, a Prince of Troy, the love of the world's most beautiful woman, Helen, if only he would judge her the fairest Goddess in a ridiculous contest that developed between Aphrodite, Hera, and Athena.
Unable to resist such a lusty bribe, the foolish Prince declared
Aphrodite the winner, which irked Hera and Athena to no end. True to
her word, Aphrodite allowed Helen to fall under the seductive charms of
young Paris.

What happened next most everyone knows - a ten year war that didn't come to an end until a certain wooden horse came on the scene.

In spite of all the pain and misery that Aphrodite brings to
those who naively think of love as a simple matter full of sunshine and
lollipops, she is still the Goddess of beauty and can be very gentle to
those who respect and understand her sensual and complex nature.