Looking through cnn.com, two headlines immediately stuck out to me.
The first, located at: http://www.cnn.com/2007/US/11/01/southern.drought/index.html, reads "Plea for Plan B in Southern drought saga." This may not confuse other people, but for someone who is very involved with women's health, Plan B is the morning after pill. I know that this just means plan b instead of the first intended plan to deal with the drought, but the wording is just off for me.
I also did not like this one on cnn.com: "Composite sketches released of girl stuffed in box" located at http://www.cnn.com/2007/US/11/02/body.found/index.html. The story following is a very emotional one that the headline seems to belittle. "Stuffed in box" is very insensitive to me.
As for good headlines, I found FOXnews.com's version of the article about the girl who was found in the box and their headline was "Texas Police Release Sketch of Girl Whose Remains Were Found in Washed Up Storage Box." For me, this is much more sensitive to the death of the little girl. I also found one on FOXNews.com entitled "Oregon Police Looking for Owners of Gnomes Without Homes." This was the headline used as a link to the article and the actual article did not have this headline, but I thought it was clever wordplay. I thought those were both good examples of a good headline.