Zapier landing page: Sure, just use a webhook trigger to Google sheets.
"Connect Trello to Gmail" is a totally different thing from "Connect Stripe to Salesforce".
I don't know about others but I favour something like StackOverflow because it's consistent and predictable. I know it will load quickly, things will be in the spot I expect, and I won't have to jump through modals to get to the content. They'd have more than 25,000 informative and templated pages ranking and it's a positive thing.
It's not a lie; it's an exaggerated truth.
It only works if the company supports it obviously, but it's a nice win for them and completely legitimate in terms of both search engines and users finding what they need.
I found Zapier many years ago because I was searching for a way to connect two specific products together. They made a page to advertise their general purpose tool as a way to solve my specific need. It was effective, and at a time when there was no other way.
Not sure why you see this as such a negative thing.
It’s garbage that this approach works for SEO. Who wakes up in the morning and decides that creating 25k versions of the same web page is a good use of time, automated or not. Apparently it pays off, but I don’t want to compete on who can generate the most fluff, and it’s bogus that this behavior is rewarded.