In your experience, that may be true. However, I've found hiding the mechanics from the players leads to frustration as the pass/fail threshold and the subsequent consequences can seem rather arbitrary in the moment.
I dont care about that.
Players should trust the DM. and the DM shouldn't abuse that trust.
As long as both of those things are happening, the game works fine.
Player: What does the wall look like?'
DM: It's slippery; water trickles down from the wall, and there is moss all over it. There are occasional handholds (takes note of the PCs Athletics skill bonus of +0), but it doesn't look easy. Dangerous even. It's about 30' to the top (mentally assigns a DC of 15 to climb, failure by 5 is a fall doing 2d6 damage)'
Player: What's the DC?
DM: You reckon you
could make it, but it's dangerous. It's up to you.
Player (pauses) OK, I'll attempt to climb it.
DM: OK; you slowly make your way up. Roll me a Strength (Athletics) check.
Players dont know the DC in my games. They dont know the consequences of failure either (but they should be apparent from the task at hand).
They trust me, and I dont abuse that trust.
Something that is missing from too many tables for mine.