Struggling with orphaned videos

We are really struggling with what to do about orphaned videos created by users who have left the company. We have 139 orphaned containers with 5TB & 27k videos with no way to connect them to anyone or any division of our company so they can be reviewed to see if they still matter. A large portion of them have been viewed in the last year and many are tagged as private so we cant just open them up to our entire company for review due to possible IP or data privacy issues.

The really frustrating part is that the Classic GUI shows the creator's name & former UPN so the data exists. We just cant get to that data in a meaningful way that allows us to reassign ownership to an M365group for migration. If we know the UPN of the departed user who created the video we can associate them with a former supervisor, company, division, etc.

The only we have been successful so far is to use a URL scraper from the classic gui under the former user's classic home page to get their video IDs. Then we create a throw away M365group to own the videos and are then able to have someone review them and migrate those videos they care about. This is not scalable. 

Not having a way to access that data, that is stored in Classic somewhere, via a report is unacceptable and needs to be resolved....