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.
I have a VPS subscription, which I use as a reverse proxy. Most of my services are on a headless computer in my bedroom. The two are connected with wireguard. (I also connect some SBC’s to the VPS to host some other services)
Works perfectly, haven’t had any connection issue or downtime expect when I manually reboot or service the case.
Currently: