I've found that the scale these start making sense is only a handful of racks. We're not talking full DCs, but a room in a building or some colo space.

And beyond that, there's all sorts of weird environments that need a lot of local compute. You'd be shocked how many servers are on a cruise ship for one example among many.