In
First Contact, it was understandable. He had a personal connection to the Borg, a very personal grudge against them, and so it was appropriate he would get into the hear of the fight. But when we continued to see "action Picard" again and again, it felt out of character and wrong.
Picard was not above a good action sequences in the series, but these were presented as the exception, rather than the rule. He was portrayed as someone who liked to use his intellect before flexing his physical muscles. In the movies, it felt backward.