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