if i were a crewmember of any rank i'd feel most comfortable under the command of Captain Picard.
Picard was always this level headed officer who tried to find a peaceful solution to any potentially volatile situation but if push came to shove he was a brilliant combat leader too.
Close second would be Sisko for much of the same reasons being taught by the same academy that produced Picard.
There are many others but many of them are pure military commanders like Adama or Sheridan which i'd like on my side when the shooting starts but for overal well roundedness it would have to be either Picard or Sisko.
However i'd drop anything to go out to party with Malcom Reynolds, Han Solo or Shatner Kirk