Sean L.,
Widow's Walk actually crossed my mind when thinking of something to add here. It's an undulating property built at the edge of a landfill through former sand-quarry land. There have been many courses built that have shown this type of land to be greatly enhanced by a golf course and vice-versa.
However, at WW, the developers and designer went with the super-environmental approach (which is how they've always advertised, with the Audubon awards and such). I found this approach to make the course claustrophobic at best, and ridiculously penal at worst. My question is why go the super-environmental route as a response to a site that man's hand has totally torn up when a regular golf course would vastly improve it anyway?
I'm all for integrating a golf course with an environmental approach, but it is possible without sacrificing the golf. So, to answer your question: They took very serviceable land and made a course that alot of people don't like, where it was very possible to conjure something much better.
Sean A.,
I thought Tralee and Rosses Point weren't the greatest of courses either (although I liked RP quite a bit), but I don't know if they belong on a "worst courses in a great setting" list. I felt the same way about Samoset in Maine (a common opinion), but the course isn't bad at all, it's just not great.