The Borg in TNG was over-used and not used practically to give you a the feeling of fear an anxiety. From the 4th time they met the Bork in “I Borg” where “Hugh” showed humanity and compassion a true friendship it was over and done for me. It showed they could be converted back and made friendly if not good members of the Federation in time.
The lost the fear facto of the BORG…. You want a good scare and antagonist, Bruce aka The Shark from JAWS, that music to this day gives people a since of danger. Bruce was used very sparingly and when he was it was to scare the living hell out of people and it worked. In VOYAGER they got it and used it that way, to bad the damage was already done by TNG.
I would actually loved to see in Voyager more of species 8472 and an alliance over time built up with them to a climatic battle. But what we got was a rushed ending. Even the Ending of Voyager leaves a kinda sour taste in my mouth, It needed to be more of the welcome home and for us to seen them at least in a time jump a few years later.
I will still like voyage and will watch it over TNG, especially now after what TNG actors have done to the show with this new one.