Establishing the Borg Queen in First Contact and later Queens with Voyager was the biggest misstep. I get that from a narrative perspective that it helps to put a face to your antagonist, but it severely de-clawed them as a whole.