I have to give Prodigy another go, the first two episodes didn't draw me in. Also unranked is TAS. I'm setting the films aside, as a separate thing, as it feels unfair to rank a whole series next to a singular films.
Top Tier Trek:
1. TNG - Still "my" Trek. Grew up with Picard and company. One of the earliest memories was seeing "Encounter at Farpoint" when it aired.
2. DS9 - Probably the best series for me if it weren't for my emotional attachment to TNG.
3. Lower Decks - Surprised me too, especially after the early episodes were rough. Early TNG is bad, but I didn't loathe the characters. The first 4 or 5 episodes of LD, I hated Mariner and Boimler. And yet they turned it around. A true love letter to Star Trek.
4. Strange New Worlds - For now, Pike and his hair go here ... but tbh, I could rearrange these top 4 in any order and defend it. And I'll revisit how I feel about SNW once it's finished. But kudos for doing an animated crossover, a musical ... an interesting episode announced for Season 4.
2nd Tier Trek:
5. TOS - The OG in 2nd tier? Yeah ... it's not like I don't like Kirk and crew, but I kinda feel like SNW is stealing its thunder, and it just has been eclipsed by its successors.
6. Picard - This show is rocky, and like Discovery, each season is practically a different series. Season 3 is probably the best qualitatively, but plays more like TNG S8. The other two seasons start strong for me, but fail to land. Season 2 is especially rocky, the last half of the season got pretty dire.
7. Discovery - Again ... each season is a very different beast, and the show had a lot of ups and downs. I give the show a lot of credit for trying to innovate, its queerness and I love Michael Burnham. However, the first three seasons all had very bad season finales and when you're telling a serialized story arc over a whole season, how it ends does tend to be the memorable part.
3rd Tier Trek:
8. Voyager - Yeah, I'll give points to Discovery for trying ... and take them away from Voyager for not. Voyager, in general, often suffers from resetting and that really deflates in the final act of a lot of episodes. In many ways, Voyager episode by episode does when Picard and Discovery did over their season long story arcs, punt in the end. The number of times the ship gets wrecked and is fine and dandy the following week ... Voyager had a lot of wasted potential.
9. Enterprise - Still the worst of Trek television. How Berman and Braga managed to suck all the charisma out of Scott Bakula continues to impress me, it's a George Lucas level feat here, as I've enjoyed the actor elsewhere. Between the hatchet job done on his character in "A Night in Sickbay" to the sulky Jack Bauer impression that is the Xindi arc season, Archer is far and away the worst lead Captain. It also feels quite regressive after DS9 and Voyager, not because it's a prequel, but because of how pale and male the cast got.