Yes, but gay refers to being homosexual - ie sexually attracted to people of the same sex. It's your sexual orientation, not your emotional orientation! Sure lots of gay men are emotionally attached to women, in my experience those who are honest with themselves usually call them friends and have the integrity not to insult them by faking sexual attraction. I'm a straight woman and I love my husband dearly but if I had a free afternoon to fill, or was stranded on a desert island, I'd rather spend it talking to my female friends - doesn't mean I have to sleep with them and pretend I'm a lesbian. Another female friend of mine is sexually attracted to men but emotionally attracted to women and she found the perfect solution in her current relationship with a transgender woman (who is physically still male). Maybe that could be another option for you.
I hope you find the right man soon that you are both physically and emotionally attracted to. I'm sure he's there if you give him a chance. It's easier to develop an emotional attachment to someone than it is to fake sexual attraction. But whatever you do please don't ruin a woman's life by subjecting her to the hurt and indiginity of a sham marriage. I have known women who have been through that and it is very ugly and unfair.