Or cumbersome mechanic cut for a good reason. Despite 20 body I played a lot of stealth, even ghosted some missions that contributed a lot that I had 160 hours in game when I finished it for the first time. Mechanic like what you describe would also limit players to invest more to body even if they want to focus more on other aspects.
For me this looks like monowire debate again.
It isn't Cumbersome, it forces you to not focus into a be-all end-all. (Stealth has been op and hasn't really evolved since Elder Scrolls model) It's a dumbing down of mechanics.
No it would not limit players to invest body. The original mechanic you could not Grapple these enemies, you had to avoid them or shoot them/melee attack them. It forces diversity or avoidance.
Look at the investment required for the Ricochet build, if they were pruning to make builds so forced into specs then you wouldn't have talents in separate trees like Ricochet. This was one of their Advertised big feature builds with Smart guns, yet no-one really uses Ricochet builds because they don't work.
Hell if you want to not limit how players play, then make perks that are used for something besides Crafting, Combat (Either direct or avoidance via stealth). They ham-fisted almost everything into combat focus.
Either way it wasn't fully cut and remains are still there.
This is no Different than just a weaker version of system of where if you attacked at night the AI started wearing Nightvision, or if you used Guns, they wore heavier and heavier armor, If you pulled headshots they wore head armor, If you used long range they turned to using rifles with scopes, if you were up close dropping people they switched to SMG/Shotguns. etc. It's just an obstacle, and at least one other game has implemented this system and it wasn't a broken mess or a cumbersome mechanic. It just forced diversity or change in gameplay style.