Picard had a lot of promise, and they almost got it, but overall it was trash IMO. More Star Wars and hand waiving than Trek. It was a beautifully made universe, the SFX were superb, but they seemed to spent all their time and money on that, and none on dialogue or character consistency. Picard is nothing of his former self. He spends three seasons whining and complaining rather than commanding. The writers invent a traumatic backstory for him, depicting his authoritative personality as a character flaw as a result of trauma, rather than a strength of character. I rather disliked what they did to him.