SF Debris pointed out that Picard's raving about not sacrificing the Enterprise-E could be in part justified because of his anger at losing the Enterprise-D in the the previous film, and lingering feelings of having lost the Stargazer before the events of TNG. Note that Picard has a look of utter horror on his face when he realizes the model he smashed in the cabinet with the gun is that of the Enterprise-D which is why his "Make them pay" rant goes off the deep end.
Another bit of Fridge Brilliance. Picard's refusal to pull back may not have been purely out of revenge. We know he could hear the Borg in his head sometimes. Who's to say they weren't still able to influence him, especially with the Borg Queen herself there. It's not that hard to believe they were giving little mental pokes to enhance feelings that were already there.
There's a reason Geordi finally opted for prosthetics, which he refused in the main show. Lursa and Betor both exploited his visor to nearly destroy the ship. That probably made Geordi decide it was for the better for security purposes.
The Bozeman is mentioned as part of the fleet to engage the Borg, and even has Kelsey Grammer reprising his role as one of the voices among the radio-chatter during the battle. The Bozeman was the ship misplaced in time and thrown forward 90 years during the TNG episode "Cause and Effect", something similar to what happens to the Enterprise in this movie. Also, the ship itself is named after Bozeman, Montana, the very site of First Contact.
Data's near-betrayal of the crew. He considered joining the Borg Queen for a fraction of a second, which, for an android, is nearly an eternity. What do you suppose ten yearsserving alongside his crewmates is then?
After Cochrane completes mankind's first warp flight, he looks and asks "Is that Earth?". Geordi answers that it is indeed Earth. Cochrane says "It's so small...", to which Riker says "It's about to get a whole lot bigger.". As in, the first contact that sets the stage for the Federation.
Cochrane confesses to Riker that he didn't build the warp drive because he wanted to travel in space or kick off a golden age of exploration, but because he wanted to make enough money to retire to some isolated tropical island full of naked women. In the original series episode "Metamorphosis", Cochrane was living (well, marooned) on an isolated planetoid, and winds up staying there with two females — the Companion and Commissioner Hedford — merged into one good-looking body. (No nudity in the script, but it's strongly implied there will be once the Enterprise leaves.)
Starfleet's decision to keep Picard out of the battle with the Borg seems unjustified, but consider what happened back in the episode "I Borg". There, Picard had a chance to do away with the Borg by introducing a Tyke Bomb but grew a conscience and refused to do so. Some episodes later (I forget which one, possibly "Descent"?), he is royally chewed out by Starfleet brass for this decision (which allows to Borg to continue). The admiralty may believe that Picard's mercy is a sign that the Borg still have some influence on him and may fear that said influence could be used to force Picard to turn the Enterprise against Starfleet. Still doesn't explain why Riker can't assume command for a few hours, though.
Maybe because they also gambled that in that situation, no matter how illegally, Riker would defer to Picard for judgment.
The rest of her rant was right, but this part was just her not understanding - there really was no way to save Lynch, and not killing him left him a threat to them.
The Defiant is swiftly defeated in battle by the Borg, even though Sisko said this was the only thing the ship was designed to do. However, he also said that it was supposed to be the first in a new Federation battle fleet. Thus, it was not designed to defeat the Borg in one-on-one combat. It was designed to be quick and cheap to build in mass numbers, allowing a swarm assault (like what Starfleet does in the battle) to defeat the Borg with acceptable casualties.
Essentially, don't think of the Defiant as the USS Missouri. Think of it as a German Type VII U-boat.
Also, considering that we reach the battle after it's been going on for awhile, and that the Defiant would probably have been on the front line the whole time, it's still one of the last ships standing.
Notice that as the Borg cube explodes, at least one Federation vessel is destroyed while failing to Outrunthe Fireball. Meanwhile the Defiant, dead in space, at ground zero of that explosion, is intact. "Tough little ship" indeed!
Combined with Nothing Is Scarier, there are few things in recent cinematic history as terrifying as hearing the audio pickup of thousands of terrified men and women ready to fight... and then hear the famous, horrifying litany that made the Borg truly fearsome- followed by screaming.
Also, psychological trauma of having been a Borg. And having to be a doctor removing the implants. And the Borg who got killed in engineering. And the people, if any, who were converted years ago and aren't from the Enterprise, currently far from everything they knew. And the ones that couldn't be saved by removing the implants because they make up so much of their body. And...
Who says any of the Borged crew members survived? The death of the Queen is accompanied by every visible drone also collapsing in a shower of sparks and convulsions. Borg are known to have built-in self destruct mechanisms that kick in when they are severed from the Collective. The only characters successfully liberated have been freed very carefully under controlled conditions.
Where did Worf get the Klingon sword he used on the deflector dish? I doubt he got it off the Defiant before being beamed aboard.
You don't think weapon collectors exist in the 24th century? A crew member on the Enterprise E could've owned it and Worf simply borrowed it for the spacewalk just in case. Or he could've gotten it from the nearest working replicator.
Maybe Riker won it in a poker bet and had it mounted on the wall in his quarters.
From a replicator?
Scarier option: he might carry one on him at all times. Just, you know, in case.