Yes, I've experienced this, too. I have a strong intellectual and emotional connection to a former professor of mine who I do NOT find physically attractive. In fact, when I met her, my first impression of her was that she was particularly unfortunate looking. She is 20 years older than me, underweight, has lots of wrinkles, has fairly strong features, doesn't have any curves, doesn't wear make-up, and dresses like a garage sale threw up on her body. (Actually, she told me some of her clothes WERE from garage sales!) So, if I were to simply see her walking down the street, not only would I not find her "hot," I'd think "yikes! poor woman needs a makeover, stat!" And yet, after collaborating with her on a project and developing a close friendship with her, I began to start fantasizing about her. I was in a relationship at the time with a woman who was ten times more attractive than the professor, and yet I frequently found my mind wandering. I started thinking about her body and being intimate with her, and yet I never started to think she was physically attractive. I felt a desire to be with her, despite not being attracted to her. I understand that attraction is emotional and intellectual (not just physical) so, in that way, it makes sense that I developed a crush on the professor. Yet, how could I want to be physically intimate with someone I did not find physically attractive? I always found it a little confusing. I could look at her hands and think "wow, they're really wrinkled and masculine and worn" and, at the same time, think "I really want her to touch me." It was an odd experience.