Usually, I’d aim for the cloud environments for public resources (serving more than like 20 people), as the traffic won’t be hitting your home network.
Additionally, selfhosting a public service like Lemmy on your home environment probably wouldn’t have the same uptime or reliability, as I only have one strong ISP signal, and no backup generator.
However, pricing wise, selfhosting at home is much cheaper for the processing power you get.
Whole-house generator. Nat gas fueled 22kw. My server rack has enough battery power to allow the generator to kick in (auto transfer switch).
It wasn’t a choice purely for the servers though. I work 100% from home and my wife about 25% and we don’t have overly reliable power so it had a lot to do with that too. I can operate just like normal even during an extended power outage.