There's a couple TNG episodes I can think of off the top of my head right away that, while maybe there was more distance back in the day, would be very up front today. The Outcast with the androgynous race and the one who claimed to start feeling female that gets cured always kind of felt like the question of "can you cure the gay" and is it okay if they're legitimately better afterwards. And the episode still framed the question as not having a correct answer. The Host, as terrible of an episode as it is, ended with Crusher not being able to get past the dude she liked turning into a chick, which now seems like a straight question about transgender shit and how humans aren't really built for that. Again, it left it up to the viewer's opinion of how they'd handle that situation and didn't really force an opinion on you. Though, I'm sure activists now would just use it just to scream their own message, sadly, even if the show is more nuanced than that.