The TNG episode with the androgynous aliens was supposed to be a homosexuality allegory by the writer. They actually wanted to cast guys as the aliens, but the producers were afraid to have Ryker kiss a guy. It wasn’t supposed to be about transsexuality, and yet the author, without being in the LGBT scene or knowing what they did, probably wrote some of the best trans TV media of that time I’m still positively surprised by TNG every time I rewatch it, knowing it’s from the end of the 70ies to the 90ies. Heck was it progressive.