After a short exploratory meeting with Alation, was pointed towards Data CookbookData Cookbook which looks promising (and apparently is used by many other universities). Will look into further and may update this answer.
http://www.datacookbook.com/videos-2/https://www.datacookbook.com/videos-2/ (as a DE, I'd recommend watching the videos in order: 1, 2, 5, 4, 3)
After watching the pre-recorded demo videos, I think it actually looks pretty good and could be what we need for our data cataloging needs (unlike the other tech/datasci. focused catalog systems I've seen with Erwin, Alation, Collibra, Amundsen, et al which focus more on structured data for more tech-centric users). Appears to be used by many other universitiesuniversities (and MSU, PSU, Birmingham U, etc.) (confirming what I had been told when initially pointed to them by the Alation people I met with). More details can be found here in this evaluation by the University of Birmingham on Data Cookbook for data governance, cataloging, and reporting: https://intranet.birmingham.ac.uk/it/innovation/documents/public/Experiments/TheDataCookBook-Evaluation-v0.1.pdf
The marketed pricing (http://www.datacookbook.com/pricing/https://www.datacookbook.com/pricing/) appears not as expensive as some other price tags I've seen
I'd also note that Lyft's Amundsen could be a good open source internal data catalog system for our own data analysts for cataloging and making-searchable our internal structured/tabled data assets.
A major question that I was still not able to discern was whether certain Defs/Specs could be hidden from certain users / only visible to a subset of catalog users. It appears so