Sisko to win a war.
Picard to prevent a war.
Kirk to defeat a superior force one on one.
Janeway to supply the coffee.
Archer to yell at aliens.
I guess I'll have to go with Picard as my favorite.
My least favorite would be Spock(I like him as a character, but don't put him in command!)
Data was in command of a ship at least once, can I pick him for a favorite? It's hard to pick a least favorite... can we promote Chakotay to captain?
Give Archer a break, guys! He's not used to making decisions solo! Normally, he has a guy from the future HELPING him! Well, helping except when he looks crazy because people see him talking to thin air.