About TNG, who am I to argue with Ursula Le Guin but it lost me after only a few episodes because it was all talking talking talking, nothing interesting to see. Plenty of shows like that (no scifi.) My friends loved it.
Also, best to start with season 3 :)
The show gets by on the reputation of later seasons, and handful of excellent episodes, and that era of TV being pretty mediocre, especially for sci-fi. S1 has basically zero good episodes (though, unfortunately, several that you kinda need to watch anyway) while S2 only has a few, and in S3 it finally really gets going. Even then, in the "good" seasons, a solid 1/4 of the episodes are pretty bad.
But it really takes off in S3 and it's a solid ride to the end, with some episodes that are stand-out best-of-era TV.
DS9 has a few of those too, but it's grittier and less obviously utopian.
The older Star Trek cared about the story and acting, despite the struggles in the first seasons of TNG the succeeded. The newer ones lacking (any) logic and are just quick action.
PS: ST Lower Decks is great :)
It's not just that they're "not Star Trek"—they're terribly written even if you pretend they're not Star Trek and are just generic sci-fi. Picard especially. My god, what a trainwreck. Like five people, zero of whom were good writers, assembled the plot using the telephone game.
SNW is, somehow, extremely good. No idea how that happened.
And yeah, Lower Decks should have sucked (that trailer, ugh) but is in fact quite good.
Modern takes on everything suck. The culture that produces modern tv/movies is not one I want to participate in, and their writers are terrible. Abrahms ability to ruin everything he touches while everyone celebrates is jusst another extension of this. The one thing the marvel MCU used to have was the ability to still tell hero stories. DC never figured it out (although there Z Snyder was at fault).
I'd rather not know what is being done now, and just cherish my memories and copies of the older material. It's less annoying and honestly there's nothing of value in the new stuff except sometimes cinematography.
I miss having shows that convey a feeling of hope for the future. The current mostly dystopian grimdark sci-fi is an easy way for unimaginative writers to make their world feel more real at the expense of destroying that hope.
It's sad that even the new Star Trek movies (post 2009) and shows courtesy of Alan Kurtzman and J.J. Abrams have completely lost that spirit of the previous Star Treks. Instead it's a bland insipid take on the Star Trek universe by people who have no clue of what makes Star Trek Star Trek and do not respect it.