Do I not like the new content because it's new and weird...? 🤔
No. I still liked DS9 and Voyager when I had grew up with TNG. I still liked Enterprise (although with some caveats mostly due to specific nerd shit that changed). I love Lower Decks and Prodigy.
What I can't get into with Picard and Discovery (haven't tried SNW yet) is the format. I really just prefer episodic content to serialized stuff. Especially when the good parts come slowly. So many people who do like these shows admit they don't get good until the 2nd or 3rd season, and I just can't slog through the first season to get that far.
SNW is probably what you want. There are some longer arcs, but for the most part, you can take things episode by episode.
The streaming era is favoring shows with long arcs, though. Just the opposite of where we were in the 90s, where missing one episode of Babylon 5 meant you might not understand what's going on, and VCRs were clunky and hard to setup right.
X-Files when it started vs X-Files when it ended. I feel like the episodic/short story formats focus on the sci fi aspects or specific situations in a way I like more.
Discovery and Picard are just bad shows to me, especially Picard. It annoys me when people try to reduce criticism to just not liking something new. The Abrams movies and Discovery depart from previous iterations in some really important ways to the point that they don't feel like the same franchise anymore.
Also really annoys me when people bring up some of the TNG movies to "prove" that old trek did some of the same annoying things, when those movies are also bad and widely criticized.
I do like SNW though. Better than Enterprise and probably Voyager as well.