The advantage of a fully local, self-contained system is that you can treat it as an appliance - you don't have to update or tinker with it continuously. There's no reason for it to update or brick itself.
A friend of mine still has a Home Assistant set up from now almost 3 years ago running with no updates or anything - it just acts like a PLC to manage some lights, switches and toggles heating on/off based on window sensors. Nobody has to mess with it and it just works in the background.