Yuuuuuuuup. It's where the infosec term "honeypot" comes from. They had code words in the Soviet union, where ladies were "swallows" and men were "ravens". Back in the day having a "raven" seduce another man was basically espionage jackpot, due to the enormous personal costs of outing the mark. Exceeded only by honeypotting the mark with children, which we might as well use the verb "epsteining". There was also a heyday of absolutely brilliant lady spy-adventurers in the period surrounding the French Revolution - this is right in the wake of Wollstonecraft, remember, what we might call the REAL first wave.

In ancient times sexpionage would flawlessly blend with the world of marriage alliances; Nefertiti, to take one example, was very likely of west Asian descent herself, and was thus a conduit for strange religions and large migrations from Hatti and Canaan. After Akenhaten's death, she probably sent for relatives, which gave impetus to the restoration of Amun, and would definitely put her closer to "spy" than unwitting spouse. I remember, there was one kooky old 19th century book, where Moses was actually Nefertiti. In drag, I guess? I need to go look that up.

Man, I wonder if anyone's written just a general survey of sexpionage through the milennia? Seems like it would sell a couple books.