I will say this:
The best NCO I have been under so far has been a lesbian. She had all her affairs in order, was good to me, was never sensitive to what she was and even made fun of it sometimes, never made an issue of her homosexuality to the unit, and she squared me away more than I ever could do for myself. In fact, when some homosexual organization invited her to a pride parade, she immediately declined it upon learning that Chelsea Manning was the honorary “queen” of that parade. I have seen similarly squared-away homosexual males as well.
That being said, though I do believe that it’s fine for homosexuals that don’t cause a fuss to serve in the military, I think that permanent transsexuals should definitely not be allowed due to the confusion they would cause in terms of quarters, paperwork, uniforms, dependency statuses, etc.