I’ve written with customer support about this who confirmed that it’s a problem. They said that it is due to an “upstream provider” of theirs and that “the upstream provider has no plans to upgrade this functionality”.
So my interpretation is that having media on strapi cloud + using custom domain is simply broken with no plan of fix.