SNW S2 so far has been hitting hard on standard Star Trek stories. Everyone's behaving as if they're in Starfleet, the stories have been a good combination of character-driven and interesting sci-fi, and I haven't found myself wanting to take any back to the draft table and re-write them (with the exception of the special green strong boy juice in "The Broken Circle" which I felt could have been accomplished with a less silly phaser fight and maybe M'Benga punching a Klingon or two.)
Similarly, I've said elsewhere that I really liked Picard S3 for the character-driven narration, even if there wasn't a lot of sci-fi to it, and I'd love to see a Star Trek: Legacy to see how Matalas tackles individual stories and such.
And Lower Decks is fantastic, full stop - always a treat to watch.
Honestly, I'm hoping for this season of SNW to finish out like it's been going, just returning to "basics of Star Trek", and then with a solid footing and understanding they can start branching out to larger ongoing plotlines and such. So maybe not 1997 yet... But I feel like the groundwork is being laid, and I'm optimistic.