The character of Sisko is great because we get to see his development. He starts out in the same idealistic mold as Picard but is forced down a very different path in order to save those ideals. And we see how the changes are reflected in different areas of his life: starfleet, bajor, friend, and father.