I know you asked the ladies, but I'm chiming in.
A long time ago when I was in high school, I had a massive ****ing crush on this girl. She was everything I wanted at the time and the messages that she kept sending me were obvious. Every time I'd look up during class, she'd be dreamily staring at me (no exaggeration) and when we'd lock eyes, she'd blush and look away. She always wanted to sit next to me, work on projects with me, talk to me, catch me outside of class and talk, etc.
One day we were supposed to be giving a speech and, being an extreme introvert, I had absolutely no desire to do so. To say I was nervous would be a massive understatement. As I got up to do the speech and looked up at the class, she was holding up this little sign that said 'you've got this' and smiling at me. It was pretty much the only thing that got me through the presentation.
This trend continued. She invited me to her house under the guise she wanted to cut my hair and insisted I take my shirt off. She was brushing my back with her hands and telling me how attractive I was... yeah.
Unfortunately, at the time, I was still stuck as a female and sort of closeted/too full of self-loathing to have enough confidence to engage in any sort of relationship. But I eventually worked up the confidence to come right out and tell her I was interested in her and had been for some time.
Her response?
"Oh... I'm not actually into girls... uh..." etc.
TL;DR, can commiserate, women make no god**** sense.