Angela Collier did an extensive bit[0] on that. Although she left out several of the canon-breaking details in the series.
That said, Patrick Stewart nailed it. Every. Single. Time. Despite the awful plotting/writing of Star Trek: Picard.
Bringing Q back was dumb. Time travel is dumb. The Borg as a metaphor of trauma and addiction is brilliant, but like every other brilliant idea it had no follow through and didn't take chances.
I didn't hate Picard as much as many other people who just wanted a Captain and a Ship and a Planet of the Week. I like it when franchises try to break out of their molds and explore new things. It just wound up being so disappointing in the end.