I categorize the Borg three ways:
There are the Q Who/BOBW Borg. Unstoppable and intimidating. Not unlike a zombie horde. It doesn't matter how many bullets you have, they will get you.
There are the I, Borg/Descent Borg - humanized and hamstrung.
Then there are the First Contact/Voyager Borg. Stripped of all their mystique, they become just another Trek villain like the Klingons or Romulans.