Mine is most memorable not because of where I played, but how I played, at least for part of the round.
For context, I'm a hacker. If I break 100, it's a good day, and if I break 90, we're having a party. Having said that, I was playing some of the best golf of my life in the mid-1990s, when I was in my late 30s. Even then, bogey golf was an accomplishment.
In August 30, 1997, I played a round at Emerald Lake Golf Club in the Charlotte suburbs with my brother. The course was relatively new at the time, and this was only the first or second time we'd played it.
After starting with a fairly routine double bogey on the par-4 first, I went into a zone and played the best five holes of my life:
#2 (402-yard par-4): Par
#3 (151-yard par-3): Par
#4 (338-yard par-4): Eagle (my first ever: holed a wedge from 95 yards)!
#5 (500-yard par-5): Birdie (reached the green in two and 2-putted)
#6 (384-yard par-4): Par
So, after six holes, one-third of the way through my round, this mediocre golfer is ONE-UNDER-FREAKING-PAR.
Mind you, my best-ever round was a 12-over 83 (on an easier course) a couple of years earlier, but at this point I just know that I'm going to do better than that, and might even have a chance to break 80.
I did my best to keep the delusions of grandeur at bay, but bogeyed #7 and #8 and double bogeyed #9 (which, to be fair, is the hardest hole on the course). Still, finishing the front 9 with a 3-over 38 puts me in great shape for the best round of my life!
Then I woke up.
Bogeys on #10, #11, and #13 (all relatively easy holes) continued the slide; triples on #12 and #14 and a quad on #15 sealed my fate. I finally made a back-9 par on #18, but the damage was done.
38 + 52 = 90 on the par-71 course. My back-9 meltdown resulted in one shot worse than bogey golf.
25+ years later, I still haven't broken 83. But I'll keep trying, and will remember that five-hole stretch for the rest of my life!