Yeah someone being non-binary or whatever and no one caring or commenting on it at all is a lot more progressive and meaningful. TOS did that really well with Uhura on the bridge. She was a black woman and absolutely no one on the ship acted like that was remotely odd. It sent a very powerful message.
I think that's part of why bringing in Seven of Nine helped the series a lot. Exploring how she adapted to being a human, when she'd been a Borg since she was a child, was much more philosophical and led to a lot of really great episodes.
A big part of Voyager's problem was that the writers had absolutely no clue what to do with Kes. You had one of the main characters being just kind of there and largely useless. Once they brought Seven of Nine in and dropped Kes Voyager got a lot better. The writers had a clear understanding of how to write for Seven and she had a ton of character development over the final four seasons. Hell, I'd even say they did a better job with Neelix once they got rid of Kes, since they couldn't keep falling back on "Neelix is super jealous of Kes interacting with any male on the crew" BS they did a lot of. (And dear god was that annoying as hell. And I like Voyager!)
All of them hold up pretty well when binging them, although I do fairly slow binges, maybe watching 3 - 4 episodes a day at most. There are episodes I dislike and I simply skip those when binging, which helps a lot. (For example DS9 is my favorite Trek but I really, really hate Vedik/Kai Wynn and skip the earlier episodes where she's being an annoying bitch. I do watch the later episodes where she's a lot more important, but I still hate her character so much. For TNG I skip all of season 1 and most of season 2.)
Back when Enterprise was airing some fan took the opening video and put it to an instrumental instead of the song and it was awesome as hell. Really wish I'd saved a copy of that now.
The scenes in the isolation chamber in underwear applying gel to each other were totally unnecessary and unpleasant to watch, especially nowadays. They have aged very poorly.
I actually liked the Temporal Cold War stuff and the Xindi arc, but that fourth season was so damn good. I wish we'd gotten at least a couple more seasons like that.
Back when Enterprise was airing some fan took the opening footage and added instrumental music to it instead and it was soooooo much better. Worked wonderfully. Really wish I'd saved a copy of it, because I can't find it anymore.
I loved all of it! I liked how they had fun with the crew being in the 2D Lower Decks style at the end, poking fun at it with the dialogue. Then they blamed it on the drinks, so it wasn't really a fourth wall break.
And on the extreme end of that was the Duras family being more like the stereotypical Romulan (and even allying with them against their own people) than a Real Klingon™. It was disgusting how they managed to keep their house throughout the series, even though they were everything a Klingon wasn't supposed to be.
I think it was less humanity's greatness that allowed them to reach the stars in the alternate timeline and more of having no choice but to do so. Earth was a wasteland and they needed more resources beyond what was available in the rest of our solar system. La'an told Kirk at one point that he could be an explorer in her timeline, heavily implying humanity doesn't do that in his.
And Robert Beltran kept upping his salary demands each season hoping they'd fire him, since they were giving him so little acting to do. But they saying yes, so he stayed.