For me, it's happened 3 times.
One time, it definitely wasn't mutual so it was just embarassing. But it wasn't the end of the world and it didn't rattle my confidence. It did make me extremely curious and out of control for a hot minute. It was overwhelming.
Another time, it happened with someone I worked with and came out of left field so to speak. I did not want to have anything to do with this man for several reasons yet I found myself sexually attracted to someone who was all wrong for me and I didn't even like that much. We'd worked together for about 6 months when it happened. It was weird and I repulsed myself. I was beating myself up over this one.
The other one, we did have a relationship. I never would have gone out with this guy more than once had it not been for that buzz. At the time, I was looking for really good sex that didn't require so much work and felt more natural. I craved that reckless abandon, a dose of wantonness. The sex was good, very good. But, he was a one hit wonder so it got stale quickly. That wouldn't be a problem if he'd been more willing to learn and try new things. But like most guys....very limited range about a lot of things. So, ultimately all the reasons I wouldn't otherwise have gone out with him for very long in the first place creeped in and got to be too much. The jealousy, the disrespect of boundaries, that doing anything new was like pulling teeth, the crippling anxieties over stupid stuff that he refused to address, etc. I even offered to pay for therapy because he would break out in a cold sweat over having to make a call sometimes.