I am a woman with Venus opposing Uranus. I have never been in a homosexual relationship, nor do I fantize about it. Having said that though, I am totally open to other people's sexual orientation and I applaud it as I applaud my own.
I am in a committed relationship and I can relate to the hot and cold feelings. My boyfriend takes it as me needing him to tell me how beautiful I am and how I am the only woman for him. But no, I could just use some space or maybe a nap. I normally feel totally gorgeous and that my boyfriend and I have a great relationship and that he's not prone to "wandering". In my mind, him not wandering has very little to do with me and more to do with where he is in his evolution.
I have a fairly grounded view of my unorthodox quest for excitement in relationships and life in general. I'm incredibly sensual as seen by some other aspects in my chart - and very aware that my unorthodox sensual nature has the potential to cause a great deal of pain and suffering if taken outside of my relationship. There are times when my boyfriend is not available during moments when I really feel the need for him and the thoughts of other men do enter into the picture. And it doesn't have to be sexual per se, it can be for affection, an emotional connection, or even just the sensuality of being in close proximity to someone that turns me on. I have a strong Neptune in Sagittarius Grand Fire Trine in my chart and my imagination has no limits! Manifesting the opposite sex during one of my "moments" is just a horrible idea, and brought down from the ethers one too many times would lead to the suffering of consequences. So, I steer clear. I have learned to channel the energies through creative outlets and not through random sexual or sensual encounters with other men.
Venus opposing Uranus people can be completely faithful. I understand that my "cold" feelings will dissipate with some space, a nap, and then loads of excitement!