Assuming we are not talking about "transformational golf experiences", I'll go with these as pleasant surprises.
Exmoor, in 2011
Plainfield, in 2004
Olympic (Lake) 2nd time around, in fall 2011.
Santa Teresa GC, in 1985 or so
Tokatee GC, in 1980
I started playing golf in 1980, but I was one of those kids from my generation that played dice-based sports games. Starting with baseball, I worked my way into golf, and that's where I became fascinated with that diagram of a great golf hole. Anybody here ever play Sports Illustrated Golf, or even better, Thinking Man's Golf?
Anyway, that's my list.