I'm so sick of hearing about how First Contact "ruined" the Borg. How could this movie possibly work without the Queen? Data would just sit in that machine and have his conversation with a bunch of simultaneous echoing voices like the crew would on the show? A bunch of Borg speaking mechanically with no passion or ambition in their voice?
So then the whole premise of the movie is flawed. They shouldn't have written there way into a spot where a Queen was necessary.
The Queen was charismatic. She had a bit of an ego about the superiority of the Borg and that made her conversations with Data interesting. And what about Picard? He would just save Data by killing all the idiot zombie drones around him instead of having that tense conversation with the Queen? What about the drama of Data tricking him into thinking she's seduced him and then revealing that he bluffed her?
I really didn't think any of those moments were particularly tense. It's all mostly an Aliens ripoff. This whole scene is pretty much Ripley going back after Newt.
As for the Queen, since when are the Borg charismatic? How does this improve them?
The Borg only being interested in technology and speaking as a group without an individual speaking on their behalf worked on TV, but concessions needed to be made for them to work as a cinematic villain and the change made for that purpose was the right one.
Or the other option is don't make a Borg movie.
It was not a shallow, mindless action movie. There was a lot of substance to the conversations between the crew and Cochrane about fate/destiny, hero worship/historical inaccuracy, and between the Queen/Data/Picard about the line between human and machine. The movie was definitely trying to have a lot more depth and substance to it than your average action movie. If anyone thinks it failed in the regard, fine, but dismissing it as a movie devoid of any intent beyond delivering cliche villains, action, and sex appeal is just selling it short just to be spiteful.
Making the Borg into zombie vampires was really a bad move and made an interesting enemy into a cliche. Its really hard to get passed that. And the fact that so much established Trek need to be retconned to make it work is just awful.