A new solution to the hated Borg Queen...
Disclaimer: If you love the idea of the Borg Queen then you probably will not like the idea presented below. Therefore it is only fair to warn you in advance that the content of this post might seem offensive even though I by no means intend to cause any - it is simply an idea and I do not claim it is any better than other ideas people have had over the years.
During the run of TNG a new alien race appeared in Star Trek. Typically most hostile species in Trek were selfish in some ways, either savage and raging like the Klingons or sly and manipulative like the Romulans, but this new race was different. They were called The Borg, and they were different because they were evil in ways that defied understanding. Mostly they were evil not because they enjoyed the suffering they caused, but rather due to their cold indifference. They had all the emotions of a machine, and with their cold precision they turned people into their willing zombies, much like vampires in old horror tales. They were scary because there were no emotions to appeal to and nothing to reason with. Not that they weren't intelligent, far from it, but the intellect that controlled the Borg was the Collective where all Borg pooled their thoughts. This made the Borg more scary because they enslaved both body and mind. As such they took away thought and freedom and became the very embodiment of anything that was in opposition to Gene Roddenberry's hopes for the future.
Then something happened... The Borg became less than they had been. Suddenly a single Borg drone could threaten the entire Collective... Then drones could be abandonned by the Collective... Then, in Star Trek: First Contact, they were suddenly not just a Collective of minds, but rather ruled by a singular entity called the Queen.
Personally I don't hate the Queen, but she does sort of ruin or lessen then horrifying ingenuity of the Borg for me because now there suddenly *is* a singular entity you can hate in the race. The very beauty of the Borg Collective was fighting them would be a losing battle because there was no weak point to attack - you could destroy a single or a single ship and it still wouldn't matter at all because it would mean nothing to the Collective. With the Queen that changed. Now killing the Queen meant disrupting the Collective. No longer was the Collective this almost omnipotent/evil god-like thing that you could not even argue against. It stopped being this infinitely superior intellect that did not whether people lived or died and didn't see any value in the individual because it was itself so much more. Instead it became this this individual that embodied the Collective, yet was still very much an individual itself. It took away from the idea because it went from being this huge collective of minds to being merely another individual. Before you could almost have excused the Collective for its evil as it did not understand the concept of what individuality was. Since that was now no longer possible, it instead became "just" another villian. Granted, the Queen might have worked as a mere embodiment of the collective, but she wasn't described as such. Indeed, she consistently used the singuler "I" over the plural "we". The consequence was unmistakable - she fully understood what she did to people, yet she did it anyway. That made her evil by the usual 'lowly' human standards, and so the 'superior evil' of the imposing Collective was lost...
However, recently I went to see Matrix Reloaded and it made me think... You might rightly ask what that has to do with the Borg Queen. Well, in the world of Matrix, one very important point is that the world isn't always what we think it is. Indeed, the very world we believe in can be a complete fabrication or lie. In that way the Matrix films are similar to the works of sci-fi authors like Philip K. Dick.
Now, why couldn't something similar be possible in Star Trek? No, I'm not saying that the Federation is an illusion, but I am wondering that maybe the Queen could be. After all, she did turn up rather conveniently in Star Trek: First Contact, and note that Borg chose a human representative to deal with the Federation when they first met them (Picard). When Picard then eluded them, the Borg might have realized something - maybe this concept of individuality was inherently destructive to their collective. Indeed, the events of TNG's "I, Borg" and later "Descent" might support that. So what do they Borg then do? Well, they send another cube to Earth, and when it fails a sphere is sent into the past. When the Enterprise follows the Borg already know the danger: Picard is free, but he can still 'touch' upon their Collective minds. That makes him dangerous to their plans, but just as he can 'hear' them, they can hear his thoughts. They sense his emotions of guilt and vengeance and give him a distraction - the Queen. They have even used the bond to Picard to give him false memories of this Queen and so give him something to focus his anger on. Why? Well, the Borg have simply analyzed humans and realized that as an authority-driven society they will usually attack the perceived leader of the enemy, so if they let them see such a leader in the queen, the Federation will most likely try to attack her instead of trying to fight the collective itself. Though the plan fails, the distraction of the queen is itself a success to such a degree that the Collective subsequently uses the tactic whenever they deal with humans from that point on, especially when they are dealing with human drones that have been freed from the collective. This explains why Seven of Nine confronted the Queen several times on Voyager as she too is a wayward drone.
Well, just an idea...
"We think we've come so far... Torture of heretics, burning of witches - it's all ancient history. Then, before you can blink an eye, suddenly it threatens to start all over again..."
- Captain Picard, "The Drumhead" (TNG).