There is a common line of thought amongst DMs (of more than just D&D) to basically not bother to ask for skill checks when failing doesn't matter. Unless the room is filling with water, if you fail to pick the lock you can just pick the lock again. Why waste everyone's time? I agree with this line of thought
This is how I see it too. It's not about getting rid of die rolls entirely. Of course you need to have die rolls for initiative and attacks and damage calculations, etc. But for skill checks, and especially in dialogue, it needs to be toned down. There is no fun involved in having to "win" five checks in a row in a dialogue to get the dialogue outcome you are trying to role-play towards. In dialogue situations, the die rolls are going against role-playing your character the way you want.
