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!
I hated this too and I saw on a YT video that if anybody says anything about a trap you can right click the mouse and the entire party will stop moving instantly. It’s not a great solution but it has helped immensely after I learned about it.