And if you haven't seen any of it, I would almost say reading the episode summaries for the first two seasons is enough. Some of those first two seasons was just catastrophically bad, even by Star Trek standards.
"No tell, only show" is a common problem in a lot of "Prestige TV" right now, leading to so many episodes feeling oddly paced where things need entire scenes across multiple episodes that probably should have been a two minute conversation. So that is not entirely a Picard flaw given how much current TV seems to suffer from it. (It certainly comes from a good intention, coming from the adage "show don't tell" taken to a logical, but awful extreme.) But it stands out a lot more in Picard especially, I think, because you watch old TNG episodes and they did so much exposition/setup in just a carefully worded "Captain's Log" and in that context it seems (at least to me) so how obvious how much could the Picard TV show have used a few more "ex-Admiral's Log" moments to just speed up a lot of filler.
While I watched all of it, I was distracted watching youtube on the side, so I didn't pay close enough attention. The following criticism might not stand to scrutiny.
I didn't like S3 (just as I didn't like the previous two seasons). An endless violation of SF protocols (random retired people overruling a captain, the entire fleet parading around Earth), bad overreaching acting, resurrecting Data for the n-th time, unconnected story plots (Picard's son, the Changelings' revenge, Borgs), also Borgs who supposedly have Agnes as the new queen and should be friendly now.
After the excellent season 1, I'm putting all my hopes into SNW S2.
I had not bothered based on 2 seasons of Discovery and 3 episodes of Picard. I just went back to DS9.
Also, from the same source as OP:
Spoilers and tangents:
It's mentioned in only a throwaway line of dialog in S3 (by Captain Shaw) that those Borg were busy elsewhere. (Though we know not what or why.)
Allegedly, Agnes' Borg are the (Memory Alpha canon) Borg Coöperative, an offshoot of the Borg that play interesting roles in Memory Beta canon (several novels, Star Trek Online), though have a different origin from Memory Beta canon and different organization structure and don't properly connect to the VOY episodes hinting at such… This is all alleged as Picard's writers didn't actually give us enough text to that affect, it's all just subtext right now in Alpha canon plus making inferences from Beta canon (and trying not to get upset that they took one of the good, fun ideas from Beta canon and nearly broke it by doing it so poorly).
(The fun of the Borg Cooperative [in Beta canon] versus the Borg Collective is that the Borg Cooperative ultimately shows that the true assimilation threat in the Star Trek galaxy, while slower and "more peaceful", is truly the Federation, especially when its ideals gets into a culture's head and won't leave. The Collective is mostly defeated and will never assimilate all of the Federation, but the Federation certainly assimilated enough Borg to form its own faction of peaceful Federation allies.)
For me, Discovery just misses the point and panders to the demands of a wider audience. The production value us excellent, very talented cast and likeable characters, but they carried the weak writing hard. The series emphasis on action and war was also punctuated mainly thanks to the characters rather than any semblance of Star Trek.
Unfortunately, this is the destiny of virtually everything, provided that the target is to maximise profit and maximising profit is equated to maximising volume and minimising risk.
Funny, now that I think about it, Quark wouldn't struggle to find a place in our society today at all. He would probably work at a big movie studio.