the one huge and quite funny flaw with that idea is that queens have absolutely jackshit power over a colony, if anything the queen of a colony is basically a slave that gets constantly pampered and directed by the workers with no free will whatsoever.
If we met an alien hive-mind species it’d probably be much like interacting with a military, just much more tightly integrated and profoundly devoid of corruption, imagine HAL 9000 but made up of a million people working together to run the computations.
So they’d likely work tirelessly to figure out what precisely we are, if they determine we’re a threat they’d attack without mercy, and if they determine they can benefit from cooperation with us they’d be the best ally we could ever imagine albeit extremely manipulative.
the borg are artificial and have the goal of assimilating as many people as possible, a realistic alien hive species wouldn’t particularly care about that beyond the inherent benefits of diversity and a higher population.
Their goal would, much like ours and that of any species, be to proliferate but primarily ensure they don’t get wiped out, which requires a lot more nuance than “resistence is futile”.
They would also inherently have a decent amount of independence, because that’s specifically how hives operate: it’s a large group of individuals operating on similar logic and working together to create what is effectively a superorganism. Bees and ants aren’t controlled by some hive mind, every individual makes small decisions and as influenced by the other individuals, and eventually one or two decisions become the most popular and are acted upon.
Hives are basically anarchic democracy taken to its absolute extreme.
