I hope this new Picard show is something entirely different. Given that it'll air alongside Discovery I see no reason for it to be another "explore the galaxy" setup.
TNG showed an evolved mankind, valuing such obscure things as kindness, non-violent solutions, and generally not being asshole.
The TV station also streams episodes but it's at 480p or lower on the Web and it's interrupted every five minutes with three minute long ads, plus you can't jump ahead or back. It's also available on CraveTV streaming service but that streaming company is terribly buggy.
But I can see myself liking Discovery (I've heard never call it STD) if I can get into a pattern of being able to watch it in sequence.
There are some truly good episodes in TNG... One of my favorites is "the first duty" which apparently was at some point required viewing at the United States air Force academy.
Overall though I like ds9 better because it's a more "honest" look at humanity... But darkness aside there's kind of an optimistic broad character arc/thesis where the good guys each in their own way is on a journey overcoming impostor syndrome (sisko, Kira, odo, Bashir, ezri, Jake, quark, rom, garak, and nog all fit this model to some degree, and even damar when he becomes a good guy basically fits this model), and the bad guys all are brought down by their classical toxic leadership attributes (dukat, Winn, weyoun, FC, but also minors like admiral leyton).
"The First Duty" is one of my least favourite episodes. I love the goofiness and variety of the first two seasons. I like Pulaski. I like it when Wesley saves the ship. I don't particularly like "The Best of Both Worlds".
"Who Watches the Watchers" would be one of my absolute favourite episodes.
(incidentally, thinking about the episode, sisko's interaction with his team serves as a microcosm of the thesis I have about DS9 as a whole in my parent comment)
As much as I enjoyed the other Treks and current Trek they seem almost self-absorbed, caring more for looks and ratings (I guess they have to) than story telling caring about the viewers. DS9 was pretty good but the producers made stupid, spiteful changes near the end, same for Enterprise.
You have to wonder what has changed that doesn't allow a series like Star Trek to be itself and instead cater to people seeking only explosions, swearing and banal story lines.