I too felt Picard season three was heavily overhyped, especially by many of the Star Trek specialty sites.
In general though, I welcome nonspoilery general early reviews, especially from less specialized professional reviewers.
In this case, I am noticing that the more mainstream reviews are the most positive and the specialized genre or franchise reviews are working for a more measured tone than with Picard.
Is it because the genre reviewers have felt the disappointment with of some of fandom with Picard, or is it because they are at heart TNG era fans? Makes one wonder.
In my own case, I can forgive much of the overly positive reviews of Picard because I really found the early episodes the strongest, with the writers doubling down on everything that most concerned me in the back half of the season. It was episode 6 where the wheels of plot and character began to come off and nostalgia was given the work of heavy lifting TNG fans through to the end.
With SNW being episodic, six episodes would seem to be enough to know if the shows continuing strongly or hitting a sophomore slump. No one yet has called slump. So it seems that those who liked season one should expect to be satisfied with season two.