I think it comes down to how reliable or fast your internet is. You can selfhost a lot of stuff with reliable internet, power, and environmental variables.
If you have any of those which are less than reliable, a VPS like Linode may make sense for uptime.
Interesting. I've been in IT for over 30 years and have always used UPS systems. Never had data loss as a result of power issues. Also, it cleans the power a bit and I get a lot of life from my hardware. Plus, I dont have to worry at all, it works as intended. My entire lab has redundant UPS systems backed by a large generator ... Zero downtime is nice.