You can always release your software under the AGPL (which is an OSI-approved license)--which would effectively prohibit its use by cloud providers. Probably very few others will use it either but that's the tradeoff you make.
Careful with AGPL. It has yet to stand in court, and is actually the license mongodb has left behind in favour of their own SSPL because it turned out not strong enough, and not preventing eg. AWS to sell mongodb as a sevice without releasing any of their provisioning and monitoring sw (though I'm not sure AWS actually uses mongo or, like Azure with CosmosDB, a proprietary API-compatible product instead). The amount of confusion regarding AGPL shows in eg. [1], and I've also heard the opinion it might not be enforcable because it wants to restrict third-party software. IANAL, but I wouldn't rely on AGPL, and not many people would use AGPL software anyway.
I don't really disagree. No one knows how "viral" (to use a loaded term) the AGPL is. But non-commercial is the same problem. I've chosen to be comfortable with using NC CC-licensed media for anything I'm not being directly compensated for. I won't use it if I'm being paid directly to give a talk or produce a marketing document but I will for a conference talk I'm giving for "free" even if it's a conference I'm attending as part of my job.
But I know other people who think that using NC content even on a personal blog that uses Adwords is a strict no-go. Or you try to define NC in terms of US tax code which is fraught for a lot of reasons.
ADDED: Personally I think the latest round of the licensing wars is overblown. If you want to use a more restrictive license, go for it. Just don't expect the development model benefits of open source software. Of course, most open source doesn't reap those benefits either because vibrant communities are relatively rare.
I believe dual-licensed or freemium models aren't after contributions so much as they want to use OSS as a marketing instrument, or for being even considered. This is also the main criticism - that they use OSS networking effects to pull a bait-and-switch strategy. OTOH, the alternatives come with their own problems: that their incentive isn't aligned with their customer's. For example, Red Hat, easily the biggest and most successful OSS company (or at least it used to be before the IBM buyout), thrived on releasing a Linux which is (intentionally?) such a complex beast that you'll need a support contract anyway.
I don't get the concern; if the AGPL is invalid, then the software user is even more screwed: they have no license to use it at all. Wining such a dispute would be a pyrrhic victory.
You can always release your software under the AGPL (which is an OSI-approved license)--which would effectively prohibit its use by cloud providers. Probably very few others will use it either but that's the tradeoff you make.