Her search for her lost love is crushed by a song about it.
Xena rescues Gabrielle from the Dionysians
Gray jedi find the power of sex.
Terry Pratchett's Conina, from "Sorcery" alternate stories