In many respects it is a superb episode. But every second spent with the Prophets drags it down, because inflicting this doesn't make sense. The suggestion that Star Trek is Benny Russell's fantasy doesn't need any Prophets. Being aware that DS9 is fiction does rather rob that of much impact.
I've seen people in extreme emotional states and Brooks isn't overacting. His character is vulnerable, not cool, and that may not be pleasant viewing. Not the same thing at all.