What was even the point of coming up with a Borg Queen? That really retcons the core of what the Borg had been established to be: a collective consciousness with no sense of individuality or hierarchy.
I think it would have worked out (and they could even have justified it since more than one actress played her) if there were multiple 'queens' and they essentially acted like central nodes, maybe even have the job of mediating a lack of consensus when a situation arises with two possible solutions. But unfortunately, that did not happen.
The Borg Queen makes total sense when you realize that a collective consciousness with no sense of individuality or hierarchy is difficult to write, and principal filming for First Contact had to start on schedule or else the studio would lose money. /s
Idea being, they're like and any colony or beehive. But that's not how queens work in either case, and swarm theory shows that they're not cooperating in any way.
The Borg Queen is a movie villain thing. A person is a better visual representation that you can show on screen, that can oppose you, and that you can converse with. All that stuff with Data being tempted and Picard's final faceoff wouldn't have worked nearly as well without a person.