haing watched all (thats right i said ALL) of the TV show's, seen all the movies and read damn near all the books i have to say .........
Picard takes it.
hes the one captian that id serve under no questions asked. hes the one captian that id WANT to serve under. hes what a captian should be, the crew and the ship come first unless its an extream situation then hes shown to be able to make the tough calls. hes a steady hand and is more likley to settle a problem with all sides happy than just saying screw it arm the phasers.
Kirk i like because hes the original and because hes a hero. the trouble with heros though is alot of people get dead to make them one. sure he comes home from every mission but its usualy with half the crew dead and a busted up ship. hes the guy i want in the captians chair when the phasers start blasting but not the guy i want on patrol , hes as apt to START a war as end one.
the others dont really diserve a mention for me because while they are captians they dont have nearly the scope in their shows/books that those first 2 do. the havent made much 'history'. most of there stuff is very much limited to their station/ship and doesnt actualy effect the whole federation. well Sisko kinda does but you get the feeling his whole story is more about his little corner of the universe than as a major player in the Star Fleet history books. future cadets wont be reading his life story dreaming of becoming just like him. same with the other 2.
from just an acting standpoint "Picard" still takes it, hes perhaps the only guy in history that can make being "french" look badass. i can see him looking Hitler in the eye and backing him down with just a speach and a shake of his head.
as for any of them id like to be, thats Riker hands down. young, second in line to the best job in the fleet, and gets more ass than a toilet seat. what more could you want?