I think the Borg Queen added much presence and charisma to the Borg as whole, in First Contact, but on hindsight added a failure point egotism and campy ham in the faceless, merciless Collective.
I've no idea that most Trek fans thought Borg nano machinery was a soft retcon in First Contact, when they've been implied right from the start, after watching a YT clip of "Q Who?" relatively recently before Christmas and just seen "The Best Of Both Worlds" earlier this evening.
Nano probes are implied, with killed or badly wounded Borg drones dissolving into the deck and a abducted Picard injected by a drone's mech arm.