This episode suffers a little bit for me by having a prophecy at the centre of it. The last time I saw it, I had also seen Buffy and Angel to death, not to mention other TV series or films that utilised it. It just made me think that a standard non-specific prophecy is nowadays a way overused tool.
Aside from that though it was good to see Sisko move towards becoming more accepting of his Emissary status. I said before season three was good for him, and this is another example.
I like Heart of Stone more than this episode, just to poke at your ratings a bit.