To be fair, portraying a gay person on screen, and doing them justice, is rather difficult.
It's not difficult at all, all you have to do is take a script, pick a random guest star who mentions his wife and replace the word "wife" with "husband".
Don't try to make a "gay episode" and doing them justice or you end up with David Gerrold's Blood and Fire which was written for TNG and filmed for the TOS fan series. The gay part of Blood and Fire was almost offensively bad, they have a gay couple and one of them kills himself because of Space AIDS.
I'm sure the episode was rejected for TNG not because of the gay couple (if that was a problem they could have made them a straight couple) but because it was stupid.
The couple served no purpose other than showing the audience that gay people have feelings too "See, they're kissing and are happy, now one of them is dead and the other one is really devastated and angry but in the end he gets better!". Well, thank you David Gerrold, you totally showed the audience that gay couples are regular people, who would have thought?! Too bad you didn't treat them like regular people but made them the centerpiece of your AIDS allegory and death drama instead.