I luckily no longer consult and now am an automation engineer for a company and I get to build things the way I want. So far a lot of Go and a little bit of Node and things are great. I'll take that any day over "We sell X, so you use X for everything."
That said, for home automation I do use Node Red and absolutely love it. The integration with Home Assistant is top notch and prototypes and tweaks take no time at all. It's much more like functional programming than a lot of low code tools and the function node allows for whatever JS you want. So if I need to do something complicated that would take a ton of individual nodes and spaghetti to work natively, I can just drop in some code and move on.
Tines is completely different - we don't rely on any prebuilt integrations - similar to postman, if you have a curl command then you can paste it into Tines, and the response is simply the json from the API you're hitting - makes it a million times easier to do exactly what you want. You can then use that response in the next action. If the API is terrible (it frequently is) we've a ton of templates to help get the relevant data, and a community with experience connecting to most tools.
Would love to talk about the challenges and see if anything we're doing (or could do) which would have made it easier? I hope you're in a better job now anyway!