Maybe not great, but pretty good IMO. I played Foxburg CC in Foxburg, PA this past weekend. It is advertised as the oldest continuously operated golf course in the USA. There were 2 holes here (out of 9) that were kinda cool in their own way:
The first one was the par 3 (blue - 155, white -146). Not too long, fairly tight on both sides, the green was somewhat concave and almost anything that hit the green from the right side, rolled right at the pin (from where it was placed that day anyway). The bunker on the back left side was pretty cool as well. I sure wouldn't want to be back in there hitting my second shot. Sorry about the dark pics, we played under the threat of rain all day! 18 with a cart was $25.
I also thought hole number 7 was also really cool. Approximately 300+ (Blue-310, White-300) yards straight downhill, with some bunkers about 40-50 yards short of the green. Out of bounds to the right, lots of trees to the left. You could hit almost ANYTHING off the tee on this hole. I liked how many options were available while standing on the tee wondering what to hit.
The clubhouse was VERY COOL as well...