And that's the big real difference with Sisko - he was written to face scenarios where there wasn't the easy 'out' or obviously correct choice that Picard was often presented with. DS9 writers didn't usually let him tech the tech and make everyone happy, or give a Kirk Speech and convince everyone. So he had to make choices between shit options. It's the 20th anniversary of In the Pale Moonlight, which simultaneously makes me feel really old (I still think of anything with the STFC uniform in it as 'new Trek') and also quite proud that the episode still holds up like it does. It presents Sisko with a version of the I, Borg dilemma, using underhand tactics to beat an enemy. But it ratchets up the stakes by making the enemy a real, present and immediate threat - Sisko faces the imminent possibility of defeat. Picard never faced annihilation because of his choice to be moral. It was all about what ifs and maybes.
Now I'm not saying he made the right choice, and I would disagree with anyone who thought his choice was presented as easy, but I love that the episode presented such a meaty problem to chew on for two decades. It (along with I, Borg actually) remains a favourite of mine. I prefer Star Trek to present difficult problems, not sanctimonious moral lessons.