See, the difference in those latter situations is that they're dealing with an actual, legitimate threat and not a vague sense of "threat" possibly brought about by depression and deepened with self-justification.
I'm confused that this misunderstanding persists. It's not a "vague sense" of anything. Sisko lived with beings who existed in the future
. Who didn't just have a sense of what the future might hold, but who directly experienced what actually would happen.
While he lived with the Prophets, he saw the future too. And while he doesn't remember specifics, he remembers knowing for a fact
that they'd be in danger if he stayed. Why is that so difficult to comprehend? It was spelled out quite clearly in the book, I thought.
In RBoE, there is no affirmation - or implication - that Sisko knew anything beyond 'You will know only sorrow'. Every time his motivation is brought up, it's always only this prophecy; there's not a trace of anything related to Sisko's stay in the wormhole (or any other source of information - unless you count depression and paranoia as such).
The 'Sisko knew more' is a forum theory, transparently meant to excuse Sisko, unsupported by RBoE.