That Sisko was being irrational due to not having moved on from his wife's death is one of the whole points of that scene. Oy gevalt.
I guess even in the first episode DS9 was muddying the protagonists and setting us up to not always root for them.![]()
It was the right choice in terms of the narrative, but you can see how it pissed off the fanboys.
I think it would have been great if Picard had made an additional cameo later in the series though - if for no other reason than to reinforce that Sisko had moved on and healed.