Plasticine879: Honestly, I feel like Star Trek died at First Contact - going forward. Everything after that doesn't exist in my mind. The Borg never had a queen. They could have easily incorporated the story from the 2nd episode with Hue, where the Borg created a queen to bring order out of chaos, but no. Picard saying "ah yes... I remember you..." in First Contact, and I almost walked out of the theater then and there.
The Borg were a frightening menace in TNG, but after First Contact just became dumb cannon fodder with a narcissistic queen. I hate what Paramount has done to Trek.
dnovraD: I take it you're not much a fan of what Voyager did to the Borg either; by downgrading them from the top dog to making them a major part of the plot and even allying with the crew against a bigger (conveniently unseen) threat.
I think your memory is failing you, the threat was very much seen. They kind of ruined Species 8472 in later episode, but Scorpion was, in my opinion, a brilliant two-parter, possibly the best Trek had after Best of Both Worlds.
But yes, Voyager pretty much ruined the Borg later on, and the Queen had a big part in it. I'm torn on First Contact, because I think that on it's own it's a great movie, one of Trek's very best, but I agree that the Borg Queen retcon was a bad idea. It just kinda works for the movie, and then falls apart when overused on Voyager.
That's why I liked the Regeneration episode of Enterprise. I think it's a real underrated gem, because it returns Borg to their former faceless, technologicaly overwhelming menace role, and wraps up the whole story contact with the Borg into a neat Terminator style closed loop. But then I'm one of the few people who always liked Enterprise.
Hell, I liked Nemesis and even the Chris Pine movies (not on the same level I like classic Trek, but I enjoy them for what they are). It wasn't until Discovery that I gave up in disgust.