Knut did a great job on the transit of Gibraltar for us recently, by pointing the ship at the rock so that we gaze at it for a while from the Observation Lounge (it was cool and windy that night.)
But in general, I'm not a big fan of captains, mostly I don't really care, I never even met Knut on Voyager. But, I really enjoyed Jeremy Kingston, late of the Diamond. He had a wonderful irony about him when giving speeches, which was fairly frequent. Oh, and very welcoming on the open bridge.