As far as New Trek for me,
I really like Lower Decks.
I watched S1 of Picard and really didn't like it. Heard S2 was also terrible but then S3 people like a bit more? Is it worth just skipping to S3 to watch that or nah?
I haven't watched any of Discovery since I heard it wasn't great. Same question: If it gets better later, is it something I can skip to or would I need to watch the earlier seasons since it's got a longer running story?
I watched SNW and... it's... alright I guess. I can see why people say it's getting closer to watch older star trek was, but it didn't really do it for me. Idk if I can really put my finger on it. The characters kind of just feel wrong.
Also, semi-related to SNW, but I've seen this elsewhere (like in the JJ Abrams movies or other pop culture references to Trek): While I don't like TOS as much as the post TNG stuff, one thing I did pull out of it was that Kirk was... a more nuanced character than his later depictions in other media. All of the non-TOS depictions I've seen of Kirk make him out to be some reckless, arrogant fly-boy. But he's just not. Sure, he flirts with aliens or gets campy a lot more than others, and he's no Picard as far as diplomacy is concerned, but for the most part he's played as an experienced captain that has his sense of duty and responsibility to his crew and mission. I get that in the JJ movies and SNW he's younger, but it still just feels like a flanderized version of what people remember him as.