TenForward: Where Every Vulcan Knows Your Name

without episodic filler episodes to shake things up which made it painfully obvious that their overarching plotlines were terrible

The other series are episode-based with some random simple overarching plotlines thrown at them so they don't feel repetitive. Yes, those plotlines can't sustain a series, but that was never the goal.

I can't talk about Picard, but Discovery has a series of really interesting ideas that were completely destroyed by the overwhelmingly bad details. The plots are not exactly terrible, they have some more complex issues, and the insistence on emotional solutions to galaxy-wide physical problems is a recurring issue there (to the point that in season 4, where a "My Little Pony" plotline makes sense, it feels empty and repetitive).

There's also:

• The Host which has Crusher dealing with falling in love with a Trill who moves hosts. It can be seen in some very specific ways as a trans allegory and just challenging heteronormative assumptions about love and attraction.

• The show really pushes a lot of 'Found Family' stuff which ends up being super popular in most LGBTQ+ media because we're disowned by other people. (Data accepted and accepting himself as part of the crew, Worf and Alexander aren't too awesome but Deanna steps up a bit there. You've got Wesley who's kind of adopted by most of the upper ranks after a while.

• TNG is purely "Infinite Diversity in Infinite Combinations" which people see as gay agenda because they wanna collapse anything pro-diversity as just being LGBTQ+ because they have fragile pathetic minds.

• Q is aggressively queer coded. The hyper dramatic and flamboyant personality, the penchant for being a theatrical whore, openly flirting with Picard (and Riker) in such a way that you genuinely aren't sure if he's joking or not, he rejects every type of rigid norm from humanity, Voyager and a few other things even hinted in such a way that due to his ability to change form he's above gendered norms too and sort of gender fluid. Not to mention being the campiest motherfucker this side of the Alpha quadrant. "It matters to me. YOU matter to me. Even Gods have favorites, Jean-Luc. You've always been one of mine." There's also his deep fucking loneliness, something that a metric fuckload of people in the community suffer from. Part of a whole but ostracized and on the outside? Yea.

I assume because the writers thought it was hilarious

To be fair, woke is a really annoying right now, essentially a conservative dog whistle for "I want to be racist but don't want to be called racist", so I don't blame a lot of people for not finishing. If I read everything that started off with woke I'd have a much higher blood pressure.

woke is the new sheeple

...in that anytime anyone uses it to support their argument you immediately know they're a grade-a fuckewit.