Well, I can't say I mind the Borg Queen really. To me, the Borg remain one of Trek's most impressive villains with or without her, but I can't say I much like the idea of a Borg Queen idea either.
, I find your parallel between the Borg and the model of society presented in Orwell's 1984
rather well-founded. But I think, in contrast to Big Brother / O'Brien, the Borg Queen ended up taking away the very idea of a collectivist juggernaut that made the Borg scary and unique in the first place. And that's why her introduction diminished the Borg's villain power.