With homeassistant you don't need yaml for 99% of automations. I'm sure OP posted the source code of the automation but used the graphical UI to make it.
You also have the possibility to use Node-Red for that.
I have used HA quite a bit and been burned. I think in the choice between graphical "no code" or "low code" and yaml, I choose yaml. But to do imperative logic there is just one useful way: a proper programming language.
This is just like when writing CI scripts for GitHub actions or Azure pipelines: the right amount of yaml (if it must be used at all) is to just invoke a program in some more expressive language than yaml.
Depending on when that was, it might make sense to try it again. I've got 25+ actively used automations and none of them need custom yaml anymore. Things really are continuously improving with every passing year.
I do use the (jinja) value templates in some places though.
