Genuinely I have no idea if this is the right sub but, the Borg were a terrific and terrifying threat in TNG, then Voyager made them a lot less deadly with the hero ship being able to destroy dozens of cubes in its time in the delta quadrant. DS9 was a refreshing breath of fresh air with a new threat in the form of the dominion who were less scary but far more dangerous because of their political influence and their sheer might. In SNW the gorn are a great main baddy due to their horror plots.

But then in Picard we simply get the Borg over and over again, and while I recognise that they are a very important part of Picards backstory and his life but its really rather boring to see the Borg again, defeated again, only to return again, and be defeated again. IMO the show should have focused more on Picard in Starfleet rather than his galavanting around the galaxy with a private ship and saving the galaxy once more.

The Borg were a great villain but they should’ve been shelved after TNG or maybe a few episodes of VOY and new shows should do what SNW does and make a new villain of their own.

Edit: A few things, for one I feel like the reason the Borg are so boring today is also in part due to the queen and the sperate Borg. What made the Borg so scary in The Best of Both worlds was that there was no one but the collective, the drones were just bodies without anything within them except for the collective. But when the introduced the Borg queen that fell apart, there was an individual and in Voyager it was shown that there was an organisational structure, which makes sense but also shows individuality.

Furthermore there have been too many Borg who got separated from the collective, especially in Voyager, which made them far less terrifying. The reason it worked for Picard was because he wasn’t fully assimilated and by allowing people to simply exit the collective it made it less scary. Unimatrix 0(i think it was called) was the final straw, allowing the Borg to exist as seperate individuals IN the collective ruined the whole concept of the Borg.