I'm also pissed about the Borg subplot - in the trailer and initial episodes, they set up the scene for some amazing drama and deep storytelling, and then they just literally crashed it into a planet and discarded like space trash. It was a huge letdown to me.
The “dystopian stereotypes” in Picard seem to me to be classic Trek with a very slight change of focus (largely in dwelling in aspects of the setting and social contexts which were indicated in other parts of the franchise but only briefly or tangentially interacted with.)
Kind of like what Lower Decks does, but in a different direction (and played for drama rather than laughs.)
So here's me hoping that in 5-10 years time, I'll fall into their "target audience" window and they'll make an inspiring, positive show for people like me.