Feb 03 2022 08:15 AM
I had to go back and read the last paragraph of your query, you will like to know the sites that use the biggest amount of storage.
This is what I will suggest,
Navigate to the SharePoint admin center (Modern Experience) and filter it with the largest sites and that should display the page in top-down of sites with the highest usage, after doing this you can visit the site itself to pick well-detailed storage metrics once you a site collection admin on the site.
As for the support request with Microsoft, I will advise you to write back to them.