I as a Voyager lover (once deeply) HATED the borg episodes.
But I have to say most of the time, it wasn’t because they made the Borg look weak. They are running away from the Borg all the time.
And even In TNG, when the Enterprise isn’t the target of the Borg, they can just beam on board and walk around, until the Collective had enough of them poking around.
In fact, until the episode Unimatrix Zero, which I hated, Borg episode either involve running away from the Borg, finding dead borg, dealing with astray Borgs, or allying with the Borg against 8472.
Unimatrix Zero involved infiltrating Unimatrix Zero to cause Borgs to retain individuality and rebel in order to do some damage.
Even though it wasn’t until End Game that they confronted the Borg headon with Future technology, I think Unimatrix is the one episode that destroyed the Borg’s image of over powering enemy.
In the end, I headed all the borg centric stories because they were so plot driven, most of them really weren’t all that memorable.