I dunno if the Borg were particularly menacing in First Contact. Their first appearances in TNG were pretty creepy because you got the feeling that they were so advanced that they pretty much completely disregarded humans as a threat so seeing these cyborgs walk past their "adversaries" casually was intimidating as fuck. But First Contact opens up with the Borg getting absolutely shit. Then they continue to ignore people. Like fuck, maybe after getting your ass beaten 2-3 times you'd start to consider humans a threat? It's really dumb how they just stand around while people ruin their work. Best example of this is when they were fucking with the deflector dish. There were like 5-6 Borg working on the deflector and they could have easily fucked up Picard and Co. But instead they wait until one of them does a bad thing and then slowly walk over to them to kill them. It's goofy as fuck. If I remember Picard even jumps over one. Makes even less sense since their """collective""" intelligence has a central intelligence (Queen) that can just order the Borg to fucking kill every crew member or cyborg their shit up. So dumb and boring.
I also think Picard was the exact opposite of believable. What happened to that Family episode where Picard came to terms with his abduction by the Borg? What about the episode I, Borg where Picard puts his feelings to the side in order to help a Borg drone become a real person? He could have killed them all then. And that somewhat boring two-parter that I forget the name of with Data, Lore, and Hugh? Nah, let's have him go fucking APESHIT. BOOM BOOM Borg BAD! Past character development BAD! Picard thinking BAD! Picard shoot big Borg with Tommy Gun GOOD! About as bad as nu-Khan in my eyes, maybe a little worse. At least Khan has the genetic engineering/background to be an action star, Picard is a balding old man that has preached pacifism and understanding for about 7 seasons.
In the end though they're both shit Trek movies. It's just that I can enjoy one a lot more than the other.
Edit: I forgot to mention that nu-Klingons look FUCKING STUPID. Dammit JJ you hack, stick to the original fucking designs.
Also I forgot to mention that I found out that Scott Bakula is the lead of Quantum Leap. I used to watch that shit all the time as a kid. Too bad they didn't just rip off the basic idea of Quantum Leap and put that in Enterprise instead of the Temporal Cold War shit. That would have actually been really fun. The more I think about it, the more I like the idea of an episode about Archer somehow being flung back in time in the middle of some social issue to set history right so he can go back to his time. Fits pretty well into Trek in my opinion.
Gonna have to disagree a little on Picard. He came to terms with what happened to him as something he had to accept as reality, even accepted Hugh and hoped returning him would would be an even nastier way to screw over the Borg than a simple virus, so he still wanted revenge, he just hoped he could do it in a way that would salve his own conscience, which, as we found out in "Descent" (the two parter with Lore), didn't pan out very well, returning Picard to square one.
And as established, Picard never really was able to separate himself from the Borg completely (which Voyager would later emphasize with Seven), and Picard's family had died by this point, so his living moral anchor that helped him past his first brush with his dark side is gone now, and since he's been through the Dominion War at this point, Picard's not half as naive or pacifistic as he used to be, so when the Borg come back and he has to prevent them from retroactively Borging all of human history, all the crap he accepted happened but never found complete closure with is now flung back in his face and made even more personal, and the novels fleshed out that little callout from Lily Sloane he got for hiding behind his high and mighty Federation morals as a cover for the fact he never really abandoned his lust for revenge, he just deluded himself into denying his motivations were as base and violent as they really were all along and that he kept pretending to himself he would eventually put the Borg behind him in a way he hoped would let him look in the mirror for the rest of his life but never did.
As for the movie, the Borg were pretty dumb, but in their defense, their Queen wanted Picard to Locutus himself again and even was fixated on winning Data over too, so due to her not keeping a close eye on the other Borg and making sure they were in 'kill and/or assimilate first and ask questions later" mode the whole time, their apparent stupidity makes some sense, and by this point, as later novels would clarify, the Borg were still trying to convince humanity to just lie down and submit (later novels had the Borg come to the realization they needed to take off the kid gloves and stop fucking around), and at least half their mission was to neutralize and or assimilate the Enterprise and Picard into their forces once again, and it's arguable their trying to convert the Enterprise into a homing beacon for the other Borg was Plan A with the other half being Plan B.
I agree it does seem kinda stupid regardless, but I still prefer First Contact because there is a lot less inconsistent bullshit I'd have to hand wave away to enjoy it.
The new Klingon designs are pretty retarded, no debate from me on that one, and damned near anything would make more sense than the Temporal Cold War crap.