Of all the cities in the US, San Diego is my favorite - the best climate by far in the country - great scenery and just about the right size. However, SD is thousands of miles from immediate family - come to think of it that may not be a bad idea
Rmac, this is an active board - you'll find polar extremes from outright cheerleading to extremely negative, vitriolic views - remember this is an opinion board - you really need to visit the area to get a feel for it
Greenville, SC Pros & Cons
Pros
Fantastic Downtown (Greenville)
The
city of Greenville is fairly progressive (bike lanes, smoking ban, etc)
Some fantastic local restaurants (Pita House, Sassafras, Rick Erwins, etc)
Great downtown festivals and activities
Numerous activities for kids: Zoo, Children's Museum, Cleveland Park, Falls Parks, Mice on Main, water parks, etc
Swamp Rabbit Trail/biking climate
Easy access to the mountains of North Carolina/Asheville
Lush/green everywhere
Moderate, 4 season climate with some snow/ice every year
Low overall cost of living (especially if you own a house in a stable, established neighborhood)
Southwest Airlines (need more direct flights)
Publix
Trader Joe's
Great place to raise a family
Cons
Outside of downtown Greenville, the Upstate is fairly non-descript and, at times, just ugly (drive down Wade-Hampton) - of course, this applies to those areas outside of the mountains
Significant sprawl
Limited upscale, aesthetically appealing shopping venues (Haywood and Greenridge do not count)
On average, disappointing/average public schools (my opinion only, a few excellent areas)
Very conservative outside of the city of Greenville (this may be a pro for some)
Yearly auto property tax - I absolutely despise paying this - outrageous sums for newer cars
Humidity - it's quite high from June thru early September - but this is typical on the East Coast