My fave Captain is Picard, without a doubt. He was more of a leader. My father always used to say that Picard realised that his position was more than personal aggrandisement - Kirk wanted to always be in on the action, whereas Picard knew that he was more valuable on board ship, rather than with the away party.
Both, however, did have the necessary nerve needed for a leader in that situation, and they both listend to advisors, but always made their own decision. Picard, though, is more distant from his crew than Kirk, and also seems more "human".
Really, cause I remember Picard leaving the deck unnecesarily many times to be in the thick of things when in fact he should have stayed with the ship and provided leadership. But then I guess we wouldn't have as interesting of stories.
What year did the Borg thing happen? I wonder if that accounts for Picards emotional distance from his crew.