Worse than that are the SEO results that don't give you what you want at all.
For products, one of the worst offenders is Target. Yes, Target. They show up near the top of about 60% of my searches, including for things they simply do not carry. But hey, they carry a similar product that you might be interested in! (not)
SEO results make Google money, but they also make the results suck.