Here's where I am.
Original trek: grew up with this, it hasn't aged terribly well, enjoy the films a lot more. And I'm obviously talking about Wrath of Khan, Undiscovered Country as the highlights.
TNG: some episodes are bad but when it's good then it's GOOD. Loved the films apart from Nemesis.
DS9: watched S1 and bailed, but I keep meaning to go back.
Voyager: watched all of this.
Enterprise: watched bits and bobs.
JJ films have left me lukewarm overall but they have a fun popcorn value, I suppose. The characters are generally good, the plots aren't. The second film was just terrible.
Discovery is OK but not ST for me so I treat it as an interesting side project.
Picard needed to do two things: tell a good story and respect the established character. It didn't do either.
Similar. My take:
TOS. Grew up with it, loved making the star trek badge out of tin foil and pretending my electronic calculator was a tricorder. Its aged quite a bit, but the storytelling and sci-fi are clever, imaginative and sound. Roddenberry created a blueprint for something unique and special.
TOS films. I dont subscribe to the odd/even 'rule'. Star Trek 1 is the pinnacle of big screen Trek and in my opinion nails the essence of what Star Trek is 100%. The 'genesis' films (Treks 2,3,4 and 6) are my other favourites and I like that they have a consistency to them (lacking in the rest of the canon).
Next gen. My favourite Trek series. Shaky start, but I think its the gold standard and Captain Picard represents the moral pinnacle of Roddenberry's future vision of humanity. Love the ship and its crew. I can watch it all day long.
DS9. Bored senseless with it until about 3 seasons in when they looked over their shoulder at Babylon 5, and went in the same direction. The serialisation of trek works well on a space station (less so on a starshp). Best space battles on TV, period. And
In The Pale Moonlight is one of the finest episodes of any television show ever made.
Voyager. Up & down with this one. Elements of the previous two shows, and lots to like.
Next Gen films. Pretty awful looking back and I include the overrated First Contact in that. Tried to make them action films to appeal to a wider cinematic audience and failed. Stuffed to the gills with plot holes.
Enterprise. Never got into it, although my mate keeps nagging me to watch it.
JJ Abrams films. Loved the first one at first, but they got stupider and more tiresome and I now think they are all empty rubbish, from a terrible storyteller.
Discovery. Very open minded to it, think its got plenty of potential yet something about it doesn't sit completely right, not sure what it is yet. However I regard it more highly now I've seen Picard.
Picard. Very nice to look at, some decent performances, and enjoyable to watch. Didn't get bored and was pleased to be back in the trek universe. Thats where my praise ends as I think the story is trite, lazy and tone deaf and misses nearly every point that separates this franchise from every other generic space opera/ dystopia. I didn't hate it though.