Things get boring when results are always guaranteed to be "good for you" and there is no risk.

The game doesn't really go that deep into what you're calling negative RNG. Most failure situations come from a player not preparing properly instead of random chance.