Out of curiosity have you tried any of the data catalogs? Alation, Informatica, Collibra? Not that they solve this problem for you but that make it solvable.
What do these do? I am constantly told by IT we need data catalogues, they talk about it, they invest money, but I have never seen the results. Me and my team keep most metadata info of tables in json files, not pretty but at least I can see what it does