Ok, now that I'm here in this thread, I might as well post some of my own thoughts on all things Trek.
I first discovered Star Trek as a teenager back in the 1990s, I think when I was 13 or 14. That age might seem a bit late by the standard of, say, US sci-fi fandom, but, you know, I was raised in a non-Trekkie educated German family in the late 20th century. At that time, among educated Germans who weren't Trekkies themselves, Star Trek was generally seen as stupid and worthless Kirk-kills-aliens stuff. See, for instance, the snide reference to Kirk in the lyrics of Nena's
99 Red Balloons. It took me a while to get over the skepticism I'd been raised with, but at 14, I was hooked.
I was, at first, mainly a TNG guy; for a while, I liked TOS, too, but I eventually decided that it was already too dated back then. Sure,
today TNG is pretty dated, too, but I'm not growing up today, and TOS was already dated when I was growing up. After a while, I got into DS9 as well. Voyager? Ok, nice, but somehow it didn't hook me the way TNG and DS9 did. My favorite Trek is still a tie between TNG and DS9 - very different shows, but both pretty good.
You know how, apparently, in the USA, every middle- or upper class nerdy white guy goes through a period in his teens when he's a libertarian or an Ayn Rand fan? Didn't happen to me - not being from the USA, and growing up without the internet, at that age I didn't even know what either of those
is. Instead, in my case, the probably weirdest thing that I seriously believed for a while as a teenager was that humans should follow Vulcan philosophy. Yes, really. I got over that eventually, but I'm
still a bit pissed that Star Trek's writers are so often so hostile towards Vulcans. What's so threatening about a bit of rationality and level-headedness?
Eventually, when I was either 18 or 17 going on 18, I discovered zompist.com, was blown away, and found that the creator of that amazing website
doesn't like Star Trek. I also found a link to
Justin B. Rye's anti-Star-Trek rant. At that age, I was still easily enough impressed that I often simply copied the opinions of people I saw as cool, so this led to me disliking Star Trek for a while. But years after that, I decided that I could be aware of Star Trek's flaws and still like it anyway.
These days, however, to some extent I seem to simply have lost interest. I'm now a Netflix subscriber, which, at least in Germany, puts the entire classical TV Star Trek canon from TOS to
Enterprise at my fingertips, but I find that I'm rarely ever interested in re-watching any of it, and even when I try, I often lose interest after a few minutes.
Enterprise could have been so great: constant tensions between three species about whom we
know that they'll eventually form an interstellar federation. But it never lived up to its potential, partly, as masako said, because the writers didn't really get that they were writing a prequel.
As for modern Trek, I don't like what they did with the Klingons in
Discovery, and I simply couldn't bring myself to care about the main plotline in
Picard, but I love love love
Lower Decks.
Oddly enough, although I'm generally very lukewarm on TOS, my favorite Star Trek
movie is a TOS movie:
The Undiscovered Country. Just great, IMO.
One final note: I think episodic TV shows, or "monster of the week" shows, are getting a bit too much of a bad rep these days. As Robert Delaney pointed out long ago, in an episodic show, if you don't like a plot, you can simply wait until the next episode; in a show that's all about long story arcs, if you don't care about the plot of one of the main story arcs, or, in the worst case,
the main story arc, you're pretty much fucked.