Star Trek: First Contact
Star Trek: First Contact is the eighth full-length motion picture in the Star Trek franchise and second movie set in the TNG time-frame.
The film begins with a Borg attack on the Federation. Jean-Luc Picard and the crew of the new Sovereign-class starship Enterprise-E, having the most experience with the Borg of anyone in Starfleet, are naturally sent off to patrol the Romulan Neutral Zone during the attack because of the fear that Picard's former assimilation might make him more of a liability in the battle than an asset. Some time during the battle, Picard and crew decide to dismiss their orders and join the battle. They arrive in time to rescue Worf and the crew of the Defiant. Picard still has some remaining Borg technology in him, allowing him to "hear" the Collective. Through this contact, he learns the exact spot needed to shoot at on the cube to destroy it. The cube is destroyed but launches a sphere before it explodes.
The Borg sphere travels back in time to the twenty-first century. Its goal is to prevent humanity's first contact with Vulcans, thus creating a new timeline where Earth is not strong enough to resist the Borg (contrary to Borg propaganda that "resistance is futile"). Firing from orbit, the sphere damages the first warp-capable ship, the Phoenix, built from an ICBM by Zephram Cochrane. Upon seeing the changes to the timeline, including a Borg-inhabited Earth, Picard orders the Enterprise-E to follow the sphere back in time to attempt to repair the timeline.
The Enterprise destroys the sphere but several Borg, including the Borg Queen transport to the Enterprise and begin assimilating the ship and crew. The surviving Borg make multiple other attempts to change history, each being subsequently thwarted. The final showdown takes place in the Borg hive in main engineering. Data, previously captured and tempted to join the Collective, fires on the Phoenix at the command of the queen. At the last second though, we see the torpedoes miss their target and we realize Data has resisted the queen's temptations. Data kills the queen by smashing a plasma coolant container which dissolves the queen's organic components, killing her, and the queen's death in turn destroys every Borg drone on the ship.
Eventually, the warp flight is made, the Vulcans come to Earth, and the Enterprise returns to its own time.
Much has been made concerning the history of the man Zefram Cochrane. He and his personality seem portrayed very different in this film than in the TOS episode "Metamorphosis", in which the character first appeared.
The Borg also appear to have been completely changed from their first conceptions. When first introduced, we are told they have no gender, are not interested in humans, just the Enterprise as something to be used. We are also initially given the distinct impression that they have no centralized leadership. We neither saw nor heard of assimilating other life forms with the injectors seen in this film. Data even comments on the contradiction of having a Queen in this film. In the film's defense however, most people's major bugbear with the post-TNG Borg (that they were literally incapable of deductive reasoning and could only understand by assimilating) actually originated with Star Trek: Voyager rather than First Contact.