I had a friend move there from Charleston after Hugo, who then got hit by the next 3 hurricanes--don't count them out for getting a few!
Pro: It is a really nice town, with lots to offer visitors and residents. I think it might be the only place I'd be willing to move from Charleston to! Great downtown area with restaurants, galleries, shops. Wonderful Azalea festival. One of my favorite coastal cities!
Con: Lots of movie and tv people, which gets on the natives' nerves. Much more expensive compared to here in housing and cost of living. Natives again blame movie and tv people for jacking up the prices. Flooding can be catastrophic, a friend's house was a total loss on the river just a few years ago, and after the second rebuild, they just gave up.
Fresh water has gators. We don't have crocodiles, but I appreciate the efforts to keep people out of the Carolinas, running bum, kind of like those Texas folks and their rattlesnake stories!