With all respect to previous posters, I don't think the options have been fairly described.......
1) Palmetto Golf Club in Aiken opens to play during Masters Week (for a handsome price). So long as price is no problem, that has to be the best available course. I'd suggest calling the club ASAP to determine availability.
2) Camden Country Club A Travis/Ross course which continues to test the best (hosting the South Carolina Mid-Am this weekend). PM me if you'd like to play, I'm a member.
3) Columbia Country Club Ellis Maples, I think..... Solid but unexciting course. Excellent conditioning, generally, with excellent greens. Private, but not too hard to access. I can probably help here.
4) Patriot Course in Greenwood. An excellent newer course from the Love Group an hour or so from Columbia.
5) Wood Creek Farms A decent Fazio; actually I think it's one of his better mid-budget offerings. Solid course with some really good holes. Private but fairly accessible. Conditioning is sometimes suspect but seems to be improving.
6) Windimere A true Pete and PB Dye, Pete did the front and PB did the back. The front is mediocre by Pete's standards but I think the back is among PB's better efforts. The combination is a fun, good test with a little quirk. Private, but easy to access.
I'd agree that Mid Carolina and Golden Hills can be fun, but neither are really good courses.
Jamey