Do people fantasize about that? I would think that the writers and show runners should get the flak for DISC, that was a terrible redemption story, “The only why to stop this war, is more war”, like wtf were they thinking?

List of captain’s major misdeeds from the top of my head-

Sisko was accomplice to murder and many war crimes by his crew. Didn’t go to jail and actually became a god.

Can’t think of any serious crimes Picard committed and got away with. There were a couple times he disobeyed orders but it was usually to save or protect someone or something, and that was few and far between.

Janeway broke the prime directive every Tuesday, except when she was stopping someone else from breaking it.

Kirk broke the temporal prime directive and the regular prime directive, routinely disobeyed orders, stole the enterprise, and wasn’t afraid to step into some morally gray areas. He got positive results, so he got demoted and promoted and demoted and got promoted to desk duty.

Pike hasn’t really stepped out of line except when he help DISC escape the rogue AI thing and breaking the temporal prime directive.

Archer was stubbling into trouble by mistake and there weren’t really any rules for him to break but I can’t think of any major crimes.

Freeman wasn’t really onscreen much but she doesn’t seem to be the start a mutiny, shoot first and start an galaxy wide war type.

Worf would never dishonor federation or his family.

Riker wasn’t on screen much but he does seem like he would get into some trouble, although when he was #1 he doesn’t seem like the mutiny and start wars type either.