Yeah, I have to agree with Luis, there. Final Frontier was daft, but kind of funny. First Contact was a crushing disappointment I wish there was an undo button for.
Main reason is that First Contact completely ruined the scariest badguys Star Trek ever came up with. When I was a kid and the Borg were introduced in TNG season 2, that episode actually gave me nightmares! It was like, space zombies, but with a rationale that actually made sense to me. No one of them any more important. No room for individuality. Kill one, kill one hundred, what did it matter? You couldn't kill them all, and they were never going to stop.
And then First Contact gave them a ****ing Borg Queen who tried to seduce Data...
...
Really? Like, did the writers even have the first clue what made the Borg so badass to begin with???
That by itself just makes the whole movie irredeemable in my eyes.