You can't really force relationships just because you want a relationship, gay or straight. That's the problem I saw in one of the Star Trek fan films a couple years back. To me the relationship they tried to make(which happened to be a gay one) seemed forced and really didn't work for me. Another one is the Checotay-Seven hook up in the last episode of that show. That seemed more hurried than anything else and came out of nowhere, but it was more forced than anything also. Some relationships click from like Mulder and Scully being meant for each other for example. Probably the best relationship in Star Trek outside of maybe the TOS one with Spock, McCoy, and Kirk is the one with O'Brien and Bashir. Now it wasn't sexual of course but that may have been a friendship just as close if not closer by the end.