Overall I did not find Picard THAT bad, sure they overdid the Borg and Q again but overall it wasn't that bad. What made people unhappy about that exactly? I just want to know which parts made people so unhappy.
Since you asked...
S1 is alright, especially by Trek S1 standards. It's an interesting premise, and it's nice to get a glimpse of what things are like at that point in the timeline. The new characters are generally nice to see and I liked the info about the xBs...I
really liked seeing Hugh again, and was fairly upset by how he was disposed of, but at least he died making a difference. The biggest stumbling point for me is the story arc and the nature of the Monster AI at the end. I wasn't expecting the universe to be threatened by Doc Ock.
S2 is a hot mess, where the first couple of episodes are the best of the whole season, and most of those aforementioned characters I enjoyed are slowly written out one way or another. When Our Heroes find themselves in the (near-)present, I expected it to last two or three episodes, not for the rest of the season. Soong's arc feels tacked on as a way to give Brent Spiner something to do, and I'm at a loss to explain Q's motives.
S3 actively pisses me off. It represents a 180 from the original premise (promise?) of the series, burying any story coherence under shameless nostalgia and calling it 'good enough'. Most of the characters I enjoyed from S1 and S2 don't even appear, and even the huge implications of the S2 finale are just swept under the rug. Captain Shaw and the return of Ro Laren are two of the only aspects that don't entirely irritate me. Even the first episode involves Beverly pleading with Picard to trust nobody and him immediately telling other people what's going on. That a rogue faction of Changelings (how much better would it have been to see what was going on with the Dominion itself?) would ally with the Borg makes zero sense to me. The appearance of the E-D at the end is technically impressive but emotionally somewhat empty to me, and again, I'm not sure it makes any sense in terms of story logic. While this isn't entirely its fault, the parallels between the series finale and the S1 finale of
Prodigy can't be overlooked either, nor can the sheer stupidity of Starfleet networking their vessels to this degree. Also, as a fan of the music of
Star Trek, it really bugs me that the composer for S1 and S2 was apparently shown the door as well.
I would very much like to see the
Picard that retains the characters and premise from S1 instead of beginning an about-face in S2 and completing it in S3.