I think i remember swen said in some interviews they plan to implement that other party members can assist with skill-checks, its just not ready yet.

Im not against RNG, on the contrary, I feel with clever design it can be a really interesting experience. Im playing Disco Elysium and i really like how they connect gameplay and story events with dice rolls: the game lets you know from the start that you have to explore things around you to increase your chances for certain checks and that encourages you from the get-go to explore more ways to abuse the dice system. Its how the game communicates these checks and with some ways it can reduce the frustration around the outcome of some bad rolls a little bit, the game can let you know or give hints for example that you got a unique outcome with failing or maybe that you can retry the check at a later time etc.

But beyond the above yeah, its part of dnd, failing is part of the fun, its just not for everybody.