The show I wanted was an exploration of cybernetics and transhumanism and the <spoiler antagonist> as the Great Filter. Unfortunately that isn't what I got.

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.