There is such a thing as too much SEO, and this article covers my personal pet peeves – no one wants to visit sites with this particular problem:
When Websites Don’t Provide What The Say They Will – By Jill Whalen
Also covered, pages that technically drone on about the subject but don’t answer the searcher’s question. Honestly, if you’re not considering both search engines and users, you can spend thousands to achieve middling or terrible success rates.
For fun, here’s an image taken from a website full of SEO fails – click on it to head over there and laugh at other’s bad website choices:
Desi