Pardon the interruption, but I nominate the Fort Mill (S.C.) Golf Club. https://playfortmill.com/
The front (Ross) nine is the best 9 holes of public golf anywhere reasonably close to Charlotte. The back has a couple of awful holes and some lengthy walks, which often cause me to do multiple loops on the front when visiting Ft. Mill.