Using Data Catalog for unstructured data

Can anyone point me to resources online that show what catalog can do with unstructured data (e.g. images, py files). I’m also weighing the value of connecting to an Azure ADLS instance through SQL to pull down file metadata and data versus using file drivers directly to blob storage for csv, xls, and json. Has anyone implemented this and if so what ‘lift’ do you get. For example does it make scan refreshes more effective when new containers/folders are created, do you get more context on folder security, more metadata on files in the folders, etc?

Thanks