hard saying, as they were rarely challenged, and when they did, yeah, it was just lay in attack pattern X!
Sisko will win, but only because he was shown in more war situations (that, and DS9 being the favorite on the board). Who else was shown in enough of those situations to even compare?
Janeway held her own in a fight. Picard has tactical classes named after his innovative thinking. Kirk was so good that an entire species decided that you weren't a real warrior until you had fought Kirk in battle. Archer even held his own despite usually being far outclassed.
On the other hand, Sisko also lost his ship. Picard as well (Stargazer, E-D doesn't count, he wasn't aboard). Janeway and Archer arrived at the end of the series with the original ships, and Kirk only lost his because he had a crew of 5 and lost the automation. Points off for Sisko and Picard there.
Anyway, don't think you can make much of a judgement here, and you don't ever see them all in similar situations, other than in ship-vs-ship battles, and in those cases, they all seemed to do just fine, and were all decent. Worst of that group is probably Picard, as they mostly just sat and absorbed a few shots, then fired once...