You mean the 2nd TNG movie "First Contact." Out of the four TNG movies, the "Borg movie" was the last Star Trek masterpiece that hit the theaters.
I would say it was more the "Leper with the most fingers". It really wasn't a good movie.
crazy person Picard was still a complete departure of what they established about his character in the series.
But I liked Picard being more ballsy and impulsively Kirk-like in the movies. It made him seem like more of a force to be reckoned with. It was a side of Picard we didn't really get to see much of in the series.