One misconception I've noticed is VOY is cited as "ruining" the Borg because they were constantly destroying Cubes and the like.
That's not the big reason. The Borg were ruined as a villain because Voyager never lost any crew to them. No deaths, no assimilations. Voyager scored over them time and time again and they were totally ineffective. Voyager liberated drones, started Borg revolts, even had some of their crew get voluntarily assimilated and then escape. There were never any consequences. This was the horrific scary villain? You could no longer take the Borg seriously as an opponent.
In TNG the Borg were the equivalent of Jason Vorhees.
In VOY they were the equivalent of Wile. E. Coyote.
It may not be the big reason, but it is a reason. I've seen loads of people say that VOY made fighting the Borg insanely easy by "constantly blowing up their ships".