Riverfront in Suffolk, VA - very flatish property (some parts of the property adjacent to wetlands and the Nansemond River very attractive), in other areas the are residences too big and too close and yet quite a course for someone who has not had much opportunity to travel ... one heck of a course.
Well, I think if you notice, the only places the houses really come in close are on 16, and those are afterthoughts, constructed after the course and likely not factored into the construction; note how the cart path changes directions, you can see the seams. However, on the note of Riverfront, I think the wetlands were a hindrance to the construction. While the holes turned out well, just look at some of the huge walks because of those wetlands being there. Especially from 14 green to 15 tee. 15 is a very good hole, but the wetlands that make it good are also a real pain when it comes to walking/routing. I would easily put Riverfront in the Overachiever category relative to original property.
And for worst on good property, that I can think of, it has to be The Pit, for me. That course, for me, is terrible. Just look at the quality work done right up the road with Tobacco Road and Tot Hill Farm. Those were on extreme sites and turned out very well. The Pit was on an extreme site and turned out nothing.