Is this like Yahoo Pipes?
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