We loved Yahoo! Pipes. While there are some similarities, the product has matured far beyond the original vision of Pipes. I encourage you to check it out as it is free for developers to start out and get a feel for it.
A few that jump to mind:
1. AI chat bots - https://pipedream.com/blog/build-your-own-chat-bot-with-open...
2. Headless browsing - https://pipedream.com/blog/puppeteer-and-playwright/
3. "Per User" workflows - https://pipedream.com/blog/connecting-your-user-accounts-to-...
4. Many use cases related to internal databases. Here is one Snowflake example we use internally - https://pipedream.com/templates/tch_WafgDD