If you want to automate complex tasks, with multiple IFs, Merge, triggers ..., easily extendable, a node based flow and self-hostable you can check out the fair-code licensed https://n8n.io
https://github.com/n8n-io/n8n
(disclaimer: I am the author)
They have a ways to go in terms of improving UX, but I think that is coming.
Yes totally agree. Still a lot to do and improve.