Let's see...
Caledonia Golf & Fish Club
Kingsbarns
Shepard's Hollow (Michigan)
Westfields (Northern VA)
Tidewater Plantation (North Myrtle Beach)
Mattaponi Springs (Ruther Glen, VA)
Cannon Ridge (Fredericksburg, VA)
Those are all well and good... Kingsbarns and Caledonia everyone has likely heard of, the rest are just little ole' publics that don't have the status of other courses discussed on here.
But then my biggest surprise perhaps ever.... Muirfield. I heard the hype, "oh it's the greatest time you'll have", "oh it's a fantastic course" blah blah blah. Holy cow, I was nowhere near prepared for my experience there. Fantastic course, we had the perfect day for it (overcast, little wind), wonderful hospitality, great food, everything. That's quite possibly my biggest surprise ever in golf.