I'm a Clemson alum, Class of 2009. I'm also from the Philadelphia area, so maybe I could give you insight on what it's like for a Yankee going to Clemson.
Clemson as a whole is definitely a conservative, rural campus, but it is also a great college town. You could knock it for being isolated, but what I liked best about going there as an undergrad was that the campus community is so strong and unified, and fellow students, faculty, even the folks at the bookstore and supplies stores downtown are friendly and 100% willing to help you with whatever work you're trying to do. It makes for a really good academic environment.
The town may not have tons of stuff to do, but downtown Clemson has plenty of bars along College Ave., some more frat-oriented, some more alternative, some more crowded, some more off the beat and track. School spirit is intense. There's nothing like tailgaiting during football weekend....the town of Clemson goes from a town of 30,000 to a city of 100,000+ overnight, then reverts back to a small town again.
Living at Clemson, or anywhere in SC, is definitely an adjustment for anyone from outside the Southeast. The people are friendly and laid back, and the pace of things is generally slower than the rest of the country. I generally always felt welcome down there, although they did like to tease me for being a yank...haha...
I am glad I went to Clemson, but I will admit that I got sort of bored with it by senior year and I've decided to go to a city school for my graduate studies. Clemson is certainly not for everybody, really no campus is. I would highly recommend you visit before you choose to go there.