I think because the Federation, and humanity, had been a thorn in the Borg's side. The Borg are highly adaptable. The reason they would go back in time to assimilate humanity when they were at their weakest is because it was the most efficient, and the Borg love efficiency. Usually they'd prefer to assimilate a culture after they reach a certain technological level. But I think in humanity's case the Borg came to the conclusion that if they assimilate Earth in the past, then they prevent the Federation from ever coming into existence and they achieve their goals much easier. But they still wanted humanity to be at a certain level of advancement. They'd only go back far enough to guarantee success. And briefly saw they were successful. If the
Enterprise had not followed them through it would have worked.
I actually can understand Picard's hatred. In "I, Borg" and "Descent" Picard's dislike of the Borg was palpable. We didn't see it as much after "The Best of Both Worlds" because they only encountered the Borg those two times. But Picard was assaulted in the most horrible way imaginable, and then forced to assist in the destruction and death of many of his fellow officers. I don't think you'd get over that. Even in Star Trek: Picard it is evident that left a permanent scare on his psyche.
Yes, I do agree on that point. That is a weakness of the story. Enterprise: "Regeneration" tried to smooth that over a bit by noting Cochrane did tell tall tales because of his alcoholism so he wasn't taken seriously. But it would have been better if the away team didn't reveal their true origins.
He still created warp drive. It was ready to go. He just needed the away team's assistance to repair the damage caused by the Borg. But it was still Cochrane's baby. I, to, was a bit put off that he was now a human from Earth. The way it has been explained since then is that Cochrane retired to Alpha Centauri and considered that his home. Alpha Centauri was settled by humans and didn't have an indigenous population. It is hard to reconcile Cochrane from First Contact and that from "Metamorphosis"--except maybe both are a bit head strong and inquisitive.
Yeah. I wanted to like "Scorpion," I really did. It was ok, there is no Star Trek I actually hate (though the Enterprise finale, TATV comes dangerously close, but that's another thread

). But I didn't like the whole "Let's make a deal" idea either. I did like that they came up with a species that was more dangerous than the Borg, but there were other things that rubbed me the wrong way. I think the only Voyager episode involving the Borg that I really liked was "Dark Frontier." The others I was just meh towards and the Borg Queen ended up making the Borg less threatening in my eyes, more human-like. I get that they wanted to add some dimension to the Borg. But the beauty of the Borg pre-Queen was their relentlessness and their singular focus. The Queen stunted some of that.
But all that being said, I did really like First Contact. I'm sorry you didn't care for it. It's not a perfect film (to me, the most perfect Star Trek film was TMP). But it's my favorite TNG film and my 3rd favorite Trek film overall.
Hmm, interesting. Can't say I've ever thought of Aliens when watching First Contact. I didn't see them as close in time for the first time as you did. Something I'll have to look for next time I watch Aliens. Another great film, BTW (though I actually liked Alien a bit more--probably because I'm also a big horror movie fan and Alien had a bit more of horror to it, while Aliens was more action oriented--which is perfectly fine, a great sequel is one that doesn't copy it's predecessor, but builds off it and does something new with it).
I did like all 4 TNG films to varying degrees. Insurrection was undoubtedly the weakest in my eyes. I still watch it from time to time, and it probably would have been fine as a TV episode. But for a Star Trek film it didn't wow me. There really wasn't anything groundbreaking about it. I liked Generations mostly, but I didn't like the method of Kirk's final death.
And I always say I'm one of the 10 people that liked Star Trek: Nemesis. I really did

It was my 2nd favorite TNG film and to this day I can't understand how much hate that movie gets. Of the 13 films I'd probably put it somewhere in the middle of the pack, but I came out of the theater thinking it was a decent film. And it has one of my favorite space battles of all the movies. The sound effects, the fact that for once we see the Enterprise using all it's weapons, and the collision scene was one of my favorites. I wish the Romulans had a greater role than they did, and I wasn't really down with the whole B-4 thing and the Kolarus scenes, but the rest of it I liked.
I guess my complaint is more fundamental. I prefer Section 31 as seen in DS9 and Enterprise. A covert cabal that operates in the shadows. That rarely takes direct action and when they do, they do it behind some sort of facade, either as a Starfleet officer in some other role, or through the official branch of Starfleet Intelligence.
A cabal like we saw in the novels--that orchestrates the resignation of a rogue Federation President through official Starfleet officers, but then quickly steps back in the shadows and lets the usual electoral process carry on after without interference.