My aunt and uncle moved to a little, well, I want to say "village" but it is really more of a stretch of one isolated McMansion track home development after another with very poor residential dwellings in between. They are about 20 minutes from Greenville so we have visited a few times. Coming from CA Bay Area there were a number of things that struck me about the area. I'm sure your impressions will be very different coming from all the way across the country from me. A few observations in no particular order.
The winters are relatively mild, though still cold (snow!) for my taste. The summers are absolutely appallingly miserable: hot, humid, buggy, never get any relief except for the occasional crashing thunderstorm. Everything is really green which is beautiful provided you are inside something with climate control.
At least in the suburban wasteland surrounding Greenville itself, there are no sidewalks, no shoulders to the roads, and everyone drives as fast as they can, which means that biking is pretty dangerous. Things are separated far apart; my guess would be that land is so cheap there is no incentive to put things in walkable/bikable distance.
I was struck by the extreme poverty in existence next to conspicuous consumption (huge houses). Greenville itself is much more comfortable in my personal taste being that it has a very nice and newly developed downtown. Others have mentioned the river and waterfalls through downtown which are very lovely. There is a long trail (swamp rabbit) that many people (including my family) use for biking and running. There are some nice restaurants downtown and the main drag is really nice for window shopping (provided it isn't a million degrees out). There is a symphony and a ballet downtown so you have the opportunity to enjoy cultural events.
Land is cheap and housing is cheap, but the flip side is that with low taxes there really isn't much investment in infrastructure (potholes in roads) and there is no social safety net to speak of. The jobs that are there tend to be quite low paying. People are very friendly but they are not yet past their racist history. In short, if you are privileged (white, educated, have money in the bank and good job prospects) you could do well there. Then again, this is merely one person's opinion and you may have very different impressions of the same observables.