God bless you for enjoying the movie as much as you did. But I have to say that my recent rewatching of FC (and all the other films, too) made me decide that I actually like it the least of all the ten movies.
It was a logical idea to use the Borg as the villain for the second TNG film. However, I feel now that the neutering of the Borg, as has often been attributed to VGR, actually began here. The Queen is one important aspect of that - It just robs this alien race of what made it special, that frightening notion of a collective mind that cannot be reasoned with - but the introduction given to them in the film is just as anticinematic as you can get. That dream, well, that's a good shot, even if it doesn't really work as a convincing pullback shot for me. But it doesn't explain. I tried to pretend this time that I didn't know anything about the Borg, and from this dream sequence alone, I didn't get that the Borg were the collective that they are. They could've just as well been a race of individuals that happen to also be cyborgs. When the Borg became scary in FC, in the deflector dish scene, most of the film was already over, so this happened too late for my taste.
I could go on and on about what rubbed me the wrong way about FC, so I'll do this briefly:
- Picard as a vengeful action hero. Doesn't work for me after his understanding of Hugh in Season 5. Doesn't work at all for his character as such.
- The Picard & Data show. The inability of the writers to come up with more than cameos for the cast of seven they had. GEN was better in that regard.
- A, B and C plots that never connect.
- Failure to achive the scope that the story idea called for. The starship battle was ordinary. Wolf 359 on DS9 was more exciting because it connected the VFX to a human component, evacuees, Jennifer Sisko's death, etc. Nothing like that was in here. Also, much of this film feels like a bottle show: Enterprise and an unconvincing human settlement on Earth.
- cheesy music. I hate the First Contact theme because it sounds to me like a nighttime soap theme song.
- Forced cameos to induce forced comedy. Especially the EMH. Everything about this scene says "deleted scene for DVD" to me.
- Casual time travel. Typical TNG nonchalance at the wonders of space: "Oh, another time vortex! Sure, we can recreate it to go back later..." Compare TVH and the drama they milked from the time travelling alone!
The list goes on. I used to like FC a lot. I was surprised myself by how little I enjoyed the movie now.