I think people are holding SNW in such high regard because when it's compared to the rest of nu-trek, it's god tier. By itself, it's ok. I like it well enough. Plenty of stinkers episodes though. I still have hope for it.
Fervently disagree, it has squandered all it could have been and the writing is still absolutely awful. Granted, it's a notch above Discovery and Picard.
The best Star Trek show is the one you like the most. If that's Discovery, that's fine. And if you don't like the show, that's also fine. But making an overall declaration that a show is terrible and tacitly expecting everyone to agree is not cool.
I'm not expecting everyone agree whether or telling anyone whether or not they should or shouldn't like it, but there are many more demonstrable issues with writing and plotting, let alone canon, that exist in excess throughout Discovery, Picard, and SNW. These are objective issues that actual writers have taken issue with, and they're consistent issues with the executive producers involved.
Absolutely TNG or DS9 aren't some pantheon of perfection, but from an overall standpoint of consistency, narrative continuity, and proper handling of characters and their development? They're lightyears beyond the juvenile handling of characters and plots in the post 09 FMV shows. It's just fact.