If you're staying up north, I highly reccomend playing the Big Cats at Ocean Ridge Plantation, they have 4 courses on site - Lions Paw, Panthers Run, Tigers Eye and Leopards Chase, all are good tracks but Tigers Eye and Leopards Chase are exceptional, 2 of the best courses in the MB area and 2 of my personal favorites, I play them both twice a year. You should also give strong consideration to The Dunes Club, Grand Dunes, Aberdeen, Long Bay,The Pearl (west course) and Oyster Bay and Carolina National and Crow Creek, all are fine courses.
If you make it down south to play a round or two then Blackmoor, The River Club, The Founders Club, The Heritage Club, World Tour Golf Links, True Blue and Caledonia are all top notch golf venues, you can't go wrong with any of them, they are all in the Pawleys Island area.
If you're ever looking for a golf package of stay and play or just play, I highly suggest going with "Golf Packages of the Carolinas.com" they are the best in the buisness in that area, they are good people and I've been going through them for 11 years running.
I play a ton of golf in the MB area (be there playing in Oct.) and have played all the courses I mentioned and many more in the area and I'm confident you will find find any of those I mentioned to your liking.