Charleston would be a very nice place to live if you're a golfer.
Assuming (big assumption) you're moving to Charleston and looking for places to join. YH and CC of Charleston are certainly the best two options close to downtown, but they are reportedly very hard places to join...especially if you're not from Charleston. Depending on how often you play, it might be worth looking into Briar's Creek on John's Island. The course was at one point a few years ago rated in the Top 100 courses in America by GD and Golf Mag, gets little play and is a fun low country course, & has great amenities. It would be maybe 30 min away from the heart of downtown, but I know they have a fair amount of local and Charleston area members.
It's also hard to beat having Kiawah 35-40 min away, as well as Hilton Head, Beaufort, Savannah within a half day's drive....and terrific weather 11 months out of the year.