DS9 = WW2 in space, and I love it. If the federation operates anything like the US military, Sisko was given that assignment out of mercy and mistrust as a safe due to his recent trauma. It was probably intended for him to give him space to grieve, adjust to being a single parent, and move on or quietly retire. The federation had no idea the can of worms the wormhole was going to be.
So this grieving single dad, a hard ass job, gets thrown into what he probably thought was going to be a boring job, that turns out he had to balance being a diplomat, equivalent of a mayor, religious icon for a politically key group, and war time military commander in the biggest war in galactic history, and absolutely crushes it. Sisko is by far the best captain in the Star Trek universe.