Maybe from the TNG point of view. As a leader you make hard decisions. As a good officer you don't abandon the ship without a fight. He is also vindicated for his actions too. Picard was obsessed with the Borg but its not like its not without good cause. How many people have the Borg killed or assimilated? You kind of need to take a hard stance with them, there is no talking it out. Was that not the point of Q showing them the Borg in the first place?
Its funny that we see his hold hand to hand as crazy but his willingness to run into engineering to save Data is heroic? Its one of Picard's finest qualities that he is determined and willing to go where angels fear to tread.