as i said in my experience with the hue ecosystem it ran for years, 5 years, with no issues. it literally was set and forget and just worked. until it died and i moved to HA i hadn't added or changed anything for at least 2 years to the point i had to install the app to my phone when the bridge died lol
I enjoy automating and doing sysadmin things for fun, but I have a life and young children. I don’t have time to tinker as much.
Home Assistant has come a long way and has been extremely reliable the last few years. I mostly use it for automating camera detections and motion/contact sensors for security.
You can be as hands on or hands off as you want to be.
In general I’ve found if you want to do any sort of automation whether store bought or tinker-level, you’re going to be wasting some time.