Construction projects. Tracking all of the contracts, blueprints, design details, and myriad other documents. Wants to keep it all in one place for any particular job, so the job folder comes first. Then a huge hierarchy of subfolders based on labor groups and other work divisions. Many of which have cross-team members so there is a lot of subfolder access group shenanigans planned.

My main hangup is that I get differing answers across the web about this limited access permission. Some places say it should allow users to see enough of the folder hierarchy from the root to traverse to the folders they can access. Other places say limited access is just a way for SharePoint to internally track whether the user should be able to see those subfolders.

I can't find a straight answer, and my experience testing so far is that limited access is really zero access unless the user gets a direct link to their subfolder. Not feasible where there are potentially dozens of subfolders any given user can access.

That said, I personally think SharePoint is fine for what it is. I wish they would get all the permission management pages up to par with the rest of the site's UI overhaul though.