... are very skilled in getting men to like them, men really easily fall in love with them, but they (the women) are not interested in anything more than a sexual relationship?
Are you trying to make the women look good, or bad? Like, are they deliberately hurting the men who fall for them, or have they been honest about their intentions and just can't help it if men don't believe them?
If you're looking for a negative metaphor, I think the Greeks could probably help. Helen of Troy springs to mind, but maybe also Pandora, the Sirens, most of the women in the Odyssey, etc. The Greeks weren't big fans of independent women. Or something more modern, although maybe overused - the black widow spider (lures males into her web, mates, kills them).
If you're looking for a more positive perspective...could you pull something out of nature? Anything that can be pleasant but that ultimately follows its own path should work, right? Like, the warmth of the sun that lasts only a while before it fades to night, the cold moon that men stare at and dream about but can't control...that sort of thing?
Good luck with it.
From "Gone With the Wind":
Melanie: That's not fair. The men naturally flock to her. Scarlett's just high spirited and vivacious.
Sue Ellen: Men may flirt with a girl like that but they don't marry them.
What about "Lady vamp" or - better - "succuba" (not "succubus")? "Succubian lady vamp"?