As someone who just briefly used Pipes for a couple of things and don't remember the service fully: What unique features of Pipes do you remember that nothing else been able to replicate?
We used pipes to aggregate multiple services into a single API a few times at Yahoo’s recommendation and it worked pretty well. Also helped get around some CORS issues IIRC.
You could make HTTP REST requests to pretty much anything and parse the result and do whatever you wanted with it.
You could use Yahoo pipes to glue APIs together.
If you were the creative sort, the possibilities were endless.
Can you name another product currently on the market that can do that?