I don't agree. I'm not going to say you are wrong, but I also don't think you're right either. I think it actually is a good thing to be taken out of your comfort zone so you can gird against one-trick pony weaknesses.
I'd agree if there wasn't a single factor
I always say:
Don't punish the player for doing the right thing.
Stealth NEEDS to be able to work perfectly.
It is a mechanic. A mechanic can not be random (if its not a specific feature of said mechanic).
Imagine if in celest or meatboy the jump is in 10% of cases half or double as high as normal.
No matter how good you are, there is no way around this. It would be frustrating, because there is no way to "solve" this.
If however there is lets say an item that you can activate, then it is in the players control, and everythign is fine.
You want to know why I became a RL 'pro' after switching from fifa (shame upon me

)?
Because the mechanic is ALWAYS the same.
If I hit the ball a certain way, it will go there 100% of times.
In fifa, if I press the pass button 100% the same, it sometimes goes up, down middle and all around. Because it is out of players control, this feature is one of the most hated features, beaten only by the P2W ultimate team.
The feature of stealth needs certain clear rules.
Step on a paper -> wakeup
Step in the light (where is light? needs a lightmeter) -> wake up
loot -> wake up
shoot with a nonsilent weapon -> wake up
right now all of these things are weird.
Sometimes they dont wake up if you shoot with a shotgun in front of them, sometimes you just sneak with 0 visibility and all perks and they wake up.
It is not consistent.
Make noise checks harder.
Add more obstacles that could do sounds. Add tripwires and stuff.
But if the player is good enough to avoid ALL of that, he needs to have a 100% sucessrate.
Why did I not like the first iteration of traps? (crane, office fall and so on)
Because there was no indication and no way to avoid it without knowing exactly what will happen.
Now traps are in a much better place. Most are telegraphed or simply don't kill you and just put you in a worse position...
But sneaking is just... the worst right now, because you can't rely on it, but you need to rely on it to survive.