I have always said that Sneak and Lockpicking needed a lot of rework, but now they have become even more primitive.
Why have sneak when it sucks?
I don't know whether you've invested in a stealth character in FONV, but 100 Sneak, Silent Running, Tunnel Runner, Travel Light, Implant M-5, and you're practically a poltergeist in the base game. The DLC is a different situation due to the their NPCs' extreme line of sight perception. A stealth, melee character also allows for the fastest way in the game to get caps:
Ask Red Lucy to fight the maximum number of deathclaws (3), and when you're in the arena, wait for the deathclaws to come out. They won't even notice you of course. Then get behind them with even Chance's Knife or Bloodnap, and queue three attacks in VATS, one for each deathclaw. Three hits is all it takes because they're all sneak attack criticals, and 500 caps is yours. Ask Red Lucy again, and repeat.