Man, I really like First Contact, but Red Letter Media makes a strong case as to how Picard acts wildly out of character given his behavior in TNG post-Best of Both Worlds. Think about how he treats Hugh for example.
Also I really really don’t like the Borg Queen.