I"m really not sure I've seen many people call Aiken "great". Rather most see it as good, or good enough as Sean says, with a great ambiance, interesting greens, walkable, affordable, not long for long's sake, and all around well done.
Another thing I like about it, is that it doesn't pretend to be anything other than what it is; a good local course. It doesn't pretend to be a "Championship" lay out, it isn't a country club for a day, it is just a good local golf course that anyone can play, anytime they want, and not get over-charged.
Golf needs more courses/facilities like this.