So, the requirements of open-source + have entity with paid hosting are both equally important. First one to ensure I can continue using whatever I setup on the hosting, in case the entity behind it cannot. And the paid hosting is important because it gives better odds towards the service actually sticking around.

What I likes with Yahoo Pipes compared to NodeRED (at least as far as I looked at NodeRED, I might be wrong) is that Yahoo Pipes worked out-of-the-box with services out of the box. I seem to remember that you could use the Google Search API for example, with Yahoo Pipes and pipe that into other things. That's what Zapier does as well, but with less flexibility than NodeRED.

So I guess my dream would be something like the integrations provided by Zapier but with the UI and flexibility of NodeRED.

Haven't seen pipes.digital before, I'll take a look as it looks interesting, but for anything serious, open source is a hard requirement (gotta learn from the Yahoo Pipes history :) )