My favourite honey trap story comes from the cold war. A Russian diplomat in Denmark was the target of Danish intelligence. They tried to honey trap him at a party, but he didn't respond to their agent's advances. So, the Danes supposed that he might be gay, and sent a male honey trap to the next party, but again got no response from the Russian. They shrugged their shoulders and gave it up.

Unbeknownst to them, the Russian was actually at that time trying to make contact with western intelligence, as he was keen to defect! He was just a bit too awkward to respond to flirting.

He did eventually manage to defect to Britain, and died in 2025. His name was Oleg Gordievsky.