Here is a compilation of the courses mentioned so far. Those with more than one mention are highlighted. Those in RED must be off the chart!
Aiken - South Carolina
Aiken Golf Club (SC)
Alamance CC (so much fun around the greens)
Alwoodley. Did not know much about the course first time I played it but was blown away
Applebrook, PA, (Hanse)
Athens CC
Atlantic
Augusta CC
Ballybunion Cashen
Ballyliffin Old
Bandon Crossings- Bandon, Or
Bandon Trails (thought it was going to be the weakest course at the resort... turns out it was amazing and unique)
Bandon Trails. Agree with what Brian Freeman said
Beau Desert
Beau Desert - joyous heathland and wonderful Fowler greens
Belvedere -MI
Bethpage Black
Black Bull - MT
Black Mesa - I had high expectations and it exceeded them. Much better than Paa Ko Ridge but at least some rankings have the order reversed.
Black Sheep
Blair Academy GC, Blairstownn, NJ, Duer Sewall
Blue Mound
Blue Mound - Wisconsin
Boone Golf Club (NC)
Brora - didn't think it would be that good, very special
Brora- A joy to play!
Burnham & Berrow (UK)
Burnham and Berrow
Cal Club - I didn't play the 'before' but the 'after' is absolutely fantastic
Caledonia Fish & Country Club
Callaway Gardens - Mtn. View (Wilson)
Camargo
Cape Cod National - had heard absolutely nothing about it, thought I would be disappointed not playing it's better know neighbor but had a lot of fun playing it
Capilano
Carnoustie - Neither ugly nor brutal
Cassique - SC
Castletown
Cavendish
CC of Greenfield, Greenfield, MA, Ralph Barton (made me think that Mr. Bahto was too hard on him)
CC of Scranton (PA) Travis
CC of Troy
Chambers Bay GC
Charles River
Charles River CC (Mass.) Ross
Citrus Course, Palm Springs CA- best non-traditional desert course I've ever played.
Cleeve Cloud
Connecticut National GC (Mungeam)
Copake CC (Emmet)
County Louth
County Louth
Coyote Crossing (West Lafayette, IN)
Crail Balcomie
Crooked Stick
Cruden Bay
Cruden Bay (knew it was good, didn't know how good)
Currituck
Cuscowilla- Ga
Dark Horse (Auburn, CA) - About as much fun as any course I've played.
Delemere Forest GC
Diamante - I had heard it was good but I was blown away (literally and figuratively)
Dismal River
Dismal River
Dismal River
Dismal River - Nebraska
Dooks
Dooks
Dooks
Dooks (Ireland)
Dunes Club - MI
Eastward Ho! CC (Mass.) Fowler
Edgewood Valley (suburban Chicago)
Elgin
Elie
Ellie
Enniscrone
Enniscrone GC
Erin Hills
Erin Hills - I thought I'd probably like it but not love it. I loved it.
Essex County - NJ
Exmoor (suburban Chicago)
Exmoor, in 2011
Fancourt Links - I hadn't played a Gary Player course I considered 'great' until seeing this place - comparable to Whistling Straits
Fenway
Ferndown
Fiddlers Elbow GC
Flinders (Australia)
Forfar
Formby
Formby
Fowlers Mill
Garden City
Giants Ridge, Minn
Glens Falls CC
Glynn's Creek (Scott County, ,IA)
Golspie
Golspie - Far from a redheaded stepkid between Dornoch and Brora. Has the best par threes of that trio & great flow.
Granville
Greywalls
Gulfstream
Hardelot (Les Pins) - Tom Simpson is God.
Harrison Hills
Highland Links, Canada
Hope Valley
Hope Valley (NC)
Hyannisport
Idle Hour - Kentucky
Idle Hour (Lexington, KY) - I knew it was good, but had no idea it would be as good as it is.
Idle Hour (Macon, Georgia)
John's Island West
Kebo Valley
Kilspindie. My favourite course to play despite lack of length or how small the property is
Kingsbarns
Kingsbarns-Really liked it more than I thought I would.
Kingsley
Kingswood GC (NH)
Kington
La Quinta Mountain
Lahinch
Lawsonia - the other courses in Wisconsin get a lot more press, but came away a lot more impresses with this often overlooked course
Lawsonia Links
Lederach
Lederach - just completely different than everything else that I had played in the vicinity of where I grew up
Leven Links
Liphook - England
Lisbon Village CC, Lisbon, NH, Ralphp Barton
Littlestone
Littlestone
Lu Lu
Luana Hills/Royal Hawaiian (not sure there's a more beautiful inland course)
Machrihanish Dunes
Marywood GC, Battle Creek, MI Maurice McCarthy
May River
May River - not what I have come to expect from Nicklaus courses. I have typically found them boring or very difficult. Since that time I have played some others that were very good so a Nicklaus design now means to me that the course will be in great condition and the design could fit anywhere within a wide spectrum.
Meadow Club
Meadow Club - arguably the best kept 'secret' in the U.S in my opinion
Mid Ocean
Mid Pines
Miner Hills
Misquamicut, RI. (Ross)
Mission Inn, Orlando
Monroe GC? Played it after Oak Hill. Again didn't know much about the course, and it was great.
Moraine
Morris County GC (NJ) Raynor
Mountain Lake
Mountain Lake
Muirfield - class, simply shear class, maybe even near perfection (?)
Murphy Creek
Nairn & Port Noo (prior to the new very narrow holes) - IRL
National
National Golf Links
National Golf Links
National Moonah
NCR South
Newport National GC
North Berwick - my ground zero
North Berwick (Wow!)
North Berwick-just awesome.
Northland- Duluth, MN
Old American
Old Elm
Old Elm
Old Tabby (Beaufort SC)
Old Works
Olympic (Lake) 2nd time around, in fall 2011.
Paiute Wolf - NV
Palatka GC, Fl- another hoot of a place to tee it. Great value, scruffy, challenging to play, and welcoming locals...perfect!
Pasatiempo - I played it in the early 90's to save money during a visit to Monterey. That was a surprise!
Pasatiempo - I was floored from 1 tee to 18 green.
Pastiempo, Calif
Pebble Beach
Pecan Valley (NLE) - I caught the course when it was in good condition due to a USGA event or something like that. I was not expecting a lot but it was very good at that time.
Pelican Waters
Peninsula North - Victoria
Pennard
Pennard
Pennard
Pennard
Pennard
Perranporth - memorably wild and wacky and crazy but just great fun
Pikewood National
Pine Dunes
Pine Tree (Boynton Beach, FL)
Plainfield, in 2004
Plantation (Ft. Myers)
Port Fairy
Portmahomack. Stumbled up on this course and just loved it. Fun little 9 holer
Portrush valley
Portsalon
Prairie Club (Dunes) - I really wasn't sure what to expect. I was blown away. It's in my personal Top 2.
Prairie Club Pines
Prairie Dunes
Prairie Dunes - One of the best five courses I have played, perfect terrain and fantastic variety and playability.
Prairie Dunes (thought it would be narrow puckerball all day)
Putterham Meadows
Rancho Santa Fe GC
Ravenna
Red Tail (MA)
Renaissance Club
Reunion Resort-Watson
Rivermont
Rivermont
Rivermont - drove by it literally 100s of times, talked golf in Atlanta many more times than that, and it never came up. Played it and joined, haven't been disappointed for a day since
Rivermont (Ga)
Roaring Gap
Rock Creek Cattle Company
Royal Cinque Ports (England)
Royal Porthcawl GC
Royal Sydney
Royal Worlington
Royal Worlington & Newmarket
Rye
Sakkonnet - RI
San Francisco Golf Club-I knew it was really good but it is GREAT
Sand Hollow (Utah)
Sand Hollow UT. Thought the course was a throw in after Mesquite, but it was a lot of fun.
Santa Teresa GC, in 1985 or so
Schaumburg GC
Seacroft - England
Seascale
Sebonack - Long Island
Shorty's - OR
Silloth
Silloth (England)
Silloth-on-Solway - But best that you don't play it from the ladies' tees like Muldoon and Arble...
Skokie GC
Sleepy Hollow (New York)
Southampton GC
Southampton Golf Club (restored)
Southampton
Southerndown
Spring Creek Ranch
Spring Valley (WI)
St. Enodoc. Did not expect much but was really impressed
St. Georges GC (LI, NY) Emmet
St. Georges(NY)
St. Germain (France)
St. Marys CC, St. Marys, PA, Devereux Emmet
Stone Eagle, CA (Doak)
Strand hill - Ireland
Sugarloaf CC (PA) (Cornish)
Tain
Tamarack CC (CT)
The Balsams - Panorama Course, Dixville Notch, NH, Donald Ross (kind of got it all started with me
The Cardinal Club
The Dunes Club Myrtle Beach. I had played a few years in a row in Myrtle and did not know this classic course existed.
The Glen
The Golf Club
The Golf Club
The Island
The New course
Thistle (best hidden gem in Myrtle)
Timuquana CC
Tobacco Rd
Tobacco Road
The Old Course
TOC - never thought the start and finish were so much 'in the town' and sooo tranquil out by the Eden
Tokatee GC, in 1980
TPC Sawgrass (really a great design...thought it would be a gimmick)
Trump Bedmimster
Tullymore
Turtle Point - Alabama
Twin Hills
Valley Club of Montecito
Vermont National GC (Nicklaus)
Wallasey
Wanumetonomy
Waveland (Des Moines, IA)
Webhannet
West Lancs
Wexford (SC)
Wexford Plantation
Wexford Plantation- Hilton Head, SC
Whirlpool
Wick great value links experience
Wilshire CC (Los Angeles, CA
Winged Foot East (thought it would just be boring, tree lined, long)
Wishaw
Wolf Point
Wolf Point
Wolf Run
Woodhall Spa - an incredible piece of architecture that reminded me of Pine Valley in many ways
Woodlands - walked on during an afternoon when my kids were at the zoo. I was bowled over by the bunkering and the interesting holes such as the 4th and 15th.
Woodlands GC - Australia
Yale, Conn