The Bitches of Westwood (1988)

Three women dissatisfied with the men they have, or don't have, in there lives decide to cast a magic spell to summon the man of their dreams. He arrives, but turns out to be something more than what they expected, but they learn how good sex can really be.