It never bothered me in Source games, but I don’t really care for it as a mechanic. Specifically in Half-Life, I don’t like how it overlaps with long jumping either. (Jump then crouch to crouch jump, crouch then jump to long jump.)
But I wouldn’t want it in other games because manteling is a superior mechanic. Mantelling is usually when you can hold down the jump key close to a ledge to grab it and pull yourself up, rather than jumping. In most games that have it, mantelling into a smaller space (a vent or pjpe) auto-crouches as you enter.
It allows for making longer jumps, exciting last moment saves, pulling yourself up into small spaces, simpler climbing mechanics, and more. It’s just a better, more intuitive mechanic that replaces long jumps and crouch jumps and requires no extra key presses.