Oops, only voted for Picard. Oh well, Picard shall always be my first choice, but the fight for 2nd and 3rd is real and difficult.
Sisko is probably 2nd, always been a solid fan of him. That said ... he faces some challengers.
Janeway used to never be one my radar, I disliked her during Voyager's initial run. But a relatively recent rewatch has made me come around on her.
Kirk (Shatner) might be the OG Captain, and I don't dislike him, but I do feel he's been eclipsed.
Kirk (Pine) ... is the shallow choice. He's so pretty. But seriously, I really liked Pine's performance and this version of Kirk.
Phillipa Georgiou, I really needed more time with her, not her Mirror counterpart (though I enjoy watching Michelle Yeoh rule the screen in either role). But it didn't take long for me to love her.
Pike (Anson Mount) ... it was about midway into the second season of Discovery when I thought that Pike might be a legitimate threat to topple Picard as my favourite captain. I would definitely watch a full series with him, Number One, and Ethan Peck's Spock.