Re: Spells for the Goddess of Love and Lust
Sounds like you need to answer some more fundamental questions first, like what social function does the church of this goddess serve? For what reason would someone plunk a coin into this church's donation box? Presumably it's more than just getting laid. Do they sanctify marriages? Preserve the distinction between romance and marriage? Protect fidelity by codifying infidelity? Preside over the transition to adulthood (sexual maturity)? Sanctify cosmetic practices?
Once you've figured that out, possible powers should be straightforward. For instance, if the church sanctifies cosmetic beauty through traditional adornments, body modifications, etc. their magic would reflect that. If sacred piercings are the norm, healing magic is an obvious choice, as well as jewelry enchanted for various purposes. Sacred tattooes imply glyphs of health, potence, etc. The sanctity of personal beauty could imply mirror magic, or even water magic, as pools are natural mirrors.
Transition to adulthood implies rites of passage, which could lead to any number of magical specialties - questing, hunting, fighting, agriculture, animal husbandry, crafting, and on and on.
It doesn't have to be, and realistically wouldn't be all about just sex.