Personally, I think that if players make a plan that the DM knows will fail, it's OK to let them execute it and taste failure.
But those are not mutualy exclusive ...
If all that would be removed was that roll ... you would get exactly same experience, except you wouldnt burn all your resources in order to gain nothing. :-/
---
This is another problem i have with Larian, they dont hold on their own rules.
Whole game Crit Failures are screwing you ... and Crit Sucesses are screwing your enemies ... HERE is the only place where it become really important ... but when its important, the rule you got used to stoped working.
Same goes for Non-lethal attacks ... whole game they have no impact on litterally anything, any important NPC you knock out is simply concidered dead from story perspective ... except when you reach Minsc ... sudently, that is the only case where rule you got used started working.
Same goes for Nere ... whole game the world is patiently waiting for you until you reach the trigger, you can walk the whole rest of the map, you can long rest for days, weeks, months, and maybe even years and nothing happens ... sudently, there is time limit nobody bothered to tell you about and if you reach it, you lock yourself out of content.
I mean ... either is fine Larian, but for ANYONE SAKE make your mind! :-/