Let me just say this, it is not becoming Myrtle Beach or Hilton Head, but for many of us that spend our weekends down there it is certainly a good place to play.
On the private side there is Hidden Creek, Galloway, Ballamor, Linwood, Stone Harbour(an adventure in itself), and at least a few others. Of those, Hidden Creek has been discussed enough on this site, and i haven't played it yet but am drooling to. Galloway is supposed to be awesome, very difficult but awesome, hoping to play there within the next month.
I have played Ballamor, and let me tell you, i like it more and more each time I play it. Ault and Clark designed it with one of their associates doing the the majority of the work. There are some really good thinking holes on this course.
On the public side you have Blue Heron East and West, Twisted Dunes, Brigatine Links, Sand Barrons, McCulloughs Links, Harbor Pines, and others, all good courses.
If you are a semi-big gambler theres a good chacne you can get on to Atlantic City CC, a Tilly redisigned by Tom Doak.
It does get crowded, and a little expensive in the summer, but it does indeed have its fair share of courses.