As a tabletop player, I confirm that failing rolls is just as fun as passing them for me (and playing no-reload is the most fun way to play). Dicerolls in dialogues are not new to BG3 though, Neverwinter Nights series also had them. And it's good that they made weighted dice optional, I'd hate to have this turned on in my game.