I think Apple just hasn't realized yet what a great sales opportunity a UI for quota management is. There's no better place to sell more storage. That's what Google does. See https://one.google.com/storage and https://photos.google.com/quotamanagement which work well for finding stuff to delete, in the hopes that eventually you'll tire of deleting things and go ahead and buy more storage.