I used to always try for the best outcome but with this have it seems like half of the time a failure also leads to an amazing consequence and story.
Like this from act one in the Underdark:
spoiler
I had to find a hidden gnome that could supply me with gunpowder, but she was so much on edge that she lit up the barrel of gunpowder and blew up the whole room, leaving half of my party dead. A suicide gnome bomber. I couldn’t convince her that I was not an enemy. Reloaded just to see if I could successfully do it, but much preferred the first outcome of the dice roll, so had to reload and try 6 times until I failed again. What a game!
It depends. Sometimes I’ll save scum a success if I rolled with a failure previously. Just to see the outcome. Usually I just roll with my failures, though.