I can attest to getting overwhelmed with it.

There are some automations I've setup that I never have issues with. Perhaps my most reliable being around lights. Not surprising the hue lights work the best. Also my hardwired locally controlled garage doors

There are some that if the power goes out I gotta log back in. Cloud is often a pain.

If it isn't on my dashboard I forget about it.

I've talked to professional installers or resellers and found similar issues with control 4 and other systems so it isn't a unique problem to Home Assistant.

This stuff gets ugly because of how complicated it is to setup, deal with multiple protocols,lack of standards or too many standards, unreliable devices, breaking changes with updates and more.