As the major search websites become more vigilant against the over-use of certain words, then those hoping for high ranking result links have learned to protect their content. Anyone invited to create articles for their sites will be warned outright against using unethical SEO practices like this.
Of course, it's still the case that careful writers will continue to incorporate those important, highly sought after triggers. They have to. If they want their answers to be matched to the question posed by their reader, then the terms need to correspond. As with everything in life, it's a case of everything in moderation.
Failure to comply will undoubtedly incur consequences. A site owner might disable the article, until it's rewritten more naturally. The more ferocious may not believe in second chances. The writer is unceremoniously kicked out and all of their work is deleted. Game over and no more revenue from that source.
No-one can say that they weren't warned. It is in the terms and conditions of every major magazine site on the internet.
Wizzley Quality Requirements: 'Articles are marked for revision by the authors when one or more of the following aspects are present: ... Keyword stuffing (excessive use of the same keyword).'
Suite101 Submission Guidelines: 'Keyword stuffing. At Suite101, we steer well clear of dubious search engine optimization, broadly speaking, anything designed to help your search performance but which weakens your article. As such, we do not accept unnatural use of keywords - including overuse and awkward use.'
Hubpages Learning Center: 'Over-use of keyword-heavy words or phrases may also result in moderation, as it falls under the category of being deceptive to searchers.'
Squidoo Terms of Service: 'If you make a lens filled with repetitive language designed to bait the search engines, we'll probably delete it. We are looking for useful, updated material that is written by a person, for a person.'
Those are only four examples. I can practically guarantee that every other writing platform will have something similar in their user agreements too.
The reason is very simple and holds as true for small, one-person blogs as it does multi-user mega-sites. Keyword stuffing is the quickest route to having your whole site deranked by search engines. This could well be the modern equivalent of the likes of Google acting like the publishing houses which rejected Emily Brontë and J.K. Rowling. But without any way for the readers to find your brilliant writing, how would anyone ever know?