I'd be lying outright if I said it always resulted in spectacular story moments, but I do feel it can lead to significantly more decision points for the players depending on the situation, and those in turn can impact the story. I find this particularly true on the clerical side of things...