The whole "Sisko part prophet " thing is one of the MANY reasons I thought season 6 and 7 (with a handful of exceptions) really went off the rails,ruining so much of the good characterisation and storytelling of the previous seasons.
Honestly I think Stephen Ira Behr got a bit full of himself towards the end.