Archiving SharePoint Library to gain back more storage

luvsql I have been doing some deep diving on this very topic. I'm leading the effort to migrate some 8 terabytes worth of data over to SharePoint/Teams. The cost of storing that much data in SharePoint document libraries is eye watering to say the very least and much of that data is archival images which don't really belong in SharePoint in the first place. 

I'd love to see a way to migrate SharePoint document libraries over to an Azure Files tier (Hot/Cold/Archive). This way we could keep current work in the very accessible SharePoint document libraries and offload old data to a much less expensive silo to access as needed. In theory I could migrate data via sync shares between SharePoint and Azure Files Sync Server... But that seems rather clunky at best an requires pulling data down from SharePoint then shipping it back up to Azure by way of the corporate WAN/LAN. 

I'll have to look at the AvePoint solution which appears to accomplish exactly what I need using Azure Files as the archive destination. I just hope their solution isn't expensive. 

I'd have to think there is some way using Power Automate to create an automation that checks SP libraries for certain criteria and then migrates the data to an Azure File Share. I've asked around and the answer I've received thus far is no.