That said "you do you" and if you want to (poorly) run a bunch of stuff on a half-dozen Rasperry Pis (or whatever) then more power to you.
On the flipside of this, the wide ranging and very robust Raspberry Pi ecosystem kicked off a surge of people self hosting all kinds of applications and getting people to leave cloud services. For whatever reasons the "look for a thin client on eBay" approach was never going to kick off the explosion of these self-hosting options and projects. So we should all be very thankful of the Raspberry Pi for that.
I'm glad that with the shortage people were forced to re-evaluate some of these approaches and projects to realize things like "Oh, this $100 used Intel XYZ is 20x faster and still low power enough to not mean anything".
With the launch of Willow and the Willow Inference Server I'm learning a lot about how people self-host and the variety is staggering. We see everything from "Well I run ABC on Pi 1, DEF on Pi 2, GHI on an old mac mini, and XYZ on an Intel NUC" to single Raspberry Pis to extremely complex Proxmox configurations. I understand a lot of this self-hosting infra grew gradually over the years but needless to say a single, cheap, reasonably powered machine can do all of that and more.