Often Picard is compared to Kirk, but I find comparing Picard to sisko to be the much more interesting one.
Picard and Sisko are both excellent, thoughtful, nearly everything you say - and sisko still is quite not happy with Picard given th circumstances of the battle against the borg they fought in together!
Great thought. I think Sisko is Picard in a much more difficult, fallen, and true to life world. The utopia is receding, the man of principal faces trauma and angry traumatized people, terrible decisions to make under pressure. He’s a sadder character in a piece of culture with less room for optimism. I quite like him, and think he was a harbinger.