I haven't started S3 of Picard, but I'm glad to hear it'll at least be watchable. The first 2 seasons were OK, but they never really "felt" like authentic Trek to me....Lower Decks I'll agree with you is great and does capture that "feel" more often, and if you've watched at least 2 different Trek series there are a ton of Easter eggs and homages to past shows that had me rolling more than once. It's nice to know that Trek can translate well to humor/animation, and still be able to pull it off.
Have to agree with you on Disco, I tried multiple times, and just could never really get into it.....way overused the Mirror Universe trope, and the whole Red Angel thing was about where I just plain lost interest.....maybe one day I'll get around to watching the rest, at least from a completion standpoint.
If you liked Lower Decks, you may also like Prodigy.... granted its geared towards kids, but I still feel like it has some really good writing, even if it feels just a little Star-Wars-y at times, I have thoroughly enjoyed it nonetheless.
Haven't seem SNW yet, but I have yet to hear anything bad about it, which is surprising considering how most 1st seasons of Trek shows usually go.
DS9, no argument here. It rarely shows its age, and watches more like something written far more recently than 20+ years ago. Just about every plotline feels relevant, perhaps even more so in a post 9/11 world. Remains my favorite out of every Trek I've watched up to this point. "In The Pale Moonlight" is still to this day some of the finest writing I have ever seen in television, Trek or otherwise.