I get this sentiment. "SEO" is basically an euphemism for spamming at this point. It's no longer just "Let's repeat this keyword 3 times" but "let's add 120 footer links and spam 35 blog comment sections per day"
I don’t think it’s how it works because I see that crap daily in footers, especially in the travel industry. Open any hotel listing on TripAdvisor and count the “[something] in [location]” links in the footer.
How do you think Google knows which pages are helpful when someone searches for “[something] in [location]”? Anchor text in links plays a key role, but with search listings on sites like TripAdvisor, it’s tricky to naturally insert those links into content. Footer links is one way to do it.
I’d agree With you if those links were misleading, but they usually aren’t. They really do point to pages with “[something] in [location]”. And they really are helpful for search engines looking to give useful results for that type of query.