The Strange New Worlds premiere was better than the Picard finale, imo. Though I'm a bit afraid it might turn into another case of fan service because it couldn't really have been any more formulaic. Not terrible, mind you. Just predictable.
But whereas Picard played to the old-timers who grew up watching TNG (the Borg, Soong, Guinan, androids, Troi and Riker, Q, etc), SNW seems to be aiming squarely at the TOS nostalgists instead.
Obviously, Discovery was a departure from both because it went down a more 2020s reboot route (more alien looking Klingons, gender politics, more equal representation between races, rainbow families, updated technology that tries to extrapolate from the present day, etc). So that was always going to upset the traditionalists who forgot that Star Trek is, at its heart, a progressive franchise.
In any case, it's pretty obvious that all three are intended to fill different niches. And all of them are watchable in their own way.
That said, I find it hilarious that people were praising the writing of Picard right up until the RedLetterMedia reviews. The scripts have always been like that. Jay and Mike just pointed it out in youtube format. Even so, it wouldn't have made sense to tell a story about the future from a 1960s or 1990s POV. I don't know why they expected any different. The optimism of the post-WW2 and Post-Berlin Wall eras that led to TOS and TNG were an illusion. We're a messy species and a messy civilisation. If new Trek ignored that reality with the current series, it wouldn't really be sci fi any more.