Back to controversial opinions...
Some episodes absolutely crap on a given character for entertainment value...
"A Night in Sickbay" - Archer. He wasn't the strongest captain in the series, but here he spends the whole night acting like a nine year old kid who needs a time-out.
"Let him who is Without Sin..." - Worf. He's gruff sometimes, but not totally incapable of enjoying himself.
"Take me out to the Holosuite" - Sisko. As someone who takes nothing but joy in baseball, he of all people should understand that it's for fun.
"Nightingale" - Harry. He's served under Janeway, Chakotay, and Tuvok, all of whom are exemplary commanders (though they have very different styles). Why would he just randomly forget the lessons he learned from them?