Top tier:
Deep Space Nine and Lower Decks.
They're both very much my kind of Star Trek as they've got the episodic 'team of smart people solving a problem' stories, smart and funny writing, characters that are fun when they're just hanging out, and the feeling that everything is taking place in a vivid living universe. They both do things I dislike as well, like DS9's magical prophets and Ferengi stories, and Lower Decks getting a bit too absurd, but overall they're my top tier.
-------------------------
Great series:
The Original Series, The Next Generation and Voyager.
These are good solid Star Trek. They're wildly varied in quality from episode to episode, and there's not a whole lot of continuity, but if you know what you're getting into they're good sci-fi and a fun time.
------------------------
Good, but...:
Enterprise, Discovery, Picard, Prodigy.
These are the series that I can't entirely love, but I can't say they didn't do a lot right.
Enterprise has three problems that hold it back for me. 1. It can be pretty dull in its stories, characters and visuals. 2. You can't have a mediocre phaser fight every episode and expect anyone to still care. 3. It got cancelled, so it didn't have three more good seasons to counter the bad start like the other shows did.
Disco has all of the problems. It retconned the Klingons, it made Burnham Spock's sister, it has a spaceship that travels through mushroom space, the spaceship contains a turbolift dimension, Burnham is the main character of reality and has to save reality twice every season... and so on. Oh plus it didn't have a clue what to do with Owo and Detmer. But it's also got a mad dramatic energy to it, and it was made by people who tried to stay true to the franchise's philosophy. And honestly, I thought the final season was just pretty solid Star Trek.
Picard also has plenty of problems, including some brand new ones like 'having creepy incest Romulans', 'being too dark to see' and 'spending half a season on the crime planet', but at worse I thought it was watchable, and at best I thought it was pretty good. That last season had some pretty great visual effects as well.
Prodigy has one big flaw and that is that I'm not 12 years old. Despite that, it's pretty solid Star Trek and does a better job with serialised storytelling than a lot of the live action series.
------------------------
Didn't enjoy it much:
The Animated Series, Strange New Worlds, Section 31, Starfleet Academy
A couple of series that claimed to be more The Original Series, and a couple of stories tried something new.
The Animated Series deserves a lot of praise for refusing to compromise. They got almost all the actors back, they stuck with the structure and setting of Star Trek, they didn't add kid sidekicks. But a series where they go to the centre of the universe to meet Satan, find a giant Spock, and go to the backwards universe was never going to be for me. Unless it was Lower Decks.
Strange New Worlds is a bottomless well of frustration for me. Sometimes it's uncanny valley Star Trek, sometimes it's sitcom hijinx, sometimes it's about love triangles. It's strength was the characters, but by season 3 I realised I didn't really like them much anymore, especially Pike. The episode which reimagined Balance of Terror was just a horrible experience, the musical showed they didn't give a damn about plausibility, and I'm just not on this series' wavelength at all in general. The props are pretty awesome though.
Section 31 is the best example of Paramount trying to grow the audience by creating something that absolutely no one wants. I'm one season into classic Mission: Impossible and I love the series so far, but there's a philosophical incompatibility there with Star Trek, and there's definitely an incompatibility with trying to rehabilitate the villains from Deep Space Nine by basically saying they were right all along. But that's not even S31's main problem! It's main problem is that it's a rubbish film with a bad story.
Starfleet Academy is a concept I have never wanted, especially when it was going to be about young Kirk and Spock. What we ended up getting isn't quite that bad, in fact it might not be bad at all if you're really into cadets falling in love and dealing with trauma and vomiting glitter and so on. It's definitely very respectful to the rest of the Star Trek setting, aside from the use of language (and a possible DS9-related exception). The series' biggest problem is that it's not my kind of thing, even as a kid I wouldn't have been drawn to a show called Space Cadet Academy, and if that's the worst I can say about it then it can't be terrible!
