I love Home Assistant for all of the reasons you list but I wouldn't say it "just works". It's the kind of thing that requires a lot of research and tinkering to get right. AI does actually help a lot here though, if you tell your agent "setup the new smart lightbulbs I just bought in Home Assistant and add them to my Living Room area", it just does it.