my understanding is the best overall perk is the one when you have 37 points in the red column as that allows you to open some tasty lockers that no one else can.
other than that I don't think they make a huge difference.
They used to (prior to me getting the perk, naturally

) have exceptional loot. Guaranteed epics and blueprints.
Then they were nerfed into oblivion, and all that was removed.
I'm exaggerating the oblivion part. They're still sometimes full of decent loot, but it's no longer a guaranteed blueprint from every locker. Or epic weapons. Or any weapons. Okay, it's hit and miss. But there are enough of them on the map that you'll get something.
The real benefit to them is that they are
almost guaranteed to have a weapon in them, so you can run a free loadout and usually grab a decent replacement if you get a rattler.
That, and they're another source of loot, which is nice for those later game starts, because not everyone has the perk to access them.
Once upon a time they were absolutely a must have. Now, not even close, you can skip it without regret.
I have the perk btw, so I'm not just ******** on it to be contrary. I also ran trios plenty of times prior to the nerf and saw how it was back then when a squad mate shared out the loot.
That said, the more I've written and the more caveats I've added to defend the perk, the more I realise how much "nerfed into oblivion" actually holds true. Writing this has made me re-evalute my own perk choices. The "they are
almost guaranteed to have a weapon in them" line I added made me realise how bad they've actually gotten.
The biggest problem I've got is, if I don't take this perk, what else is there? The whole perk system seems meh. Aside from stamina stuff which seems mandatory.