[DELETED]

Bad keyword density, proximity, prominence and frequency are the most common problems on sites that I'm asked to engineer.

Gateway pages, cloaking, stuffing and other black hat techniques are fairly common too, all which should never be done.

the biggest problem is trying to optimize for keywords that have a very low traffic volumes, other than that you have getting quality links and so on.