Outside of work I prefer NY much more than SC. The winters are long up here but if you're into winter sports (snowboarding, skiing, ice fishing, snowmobiling, etc.) it makes it more bearable. The other three seasons here are great. You've got NYC, Montreal, Boston, Niagara Falls and Philly all reasonably close, Lake George, racing season in Saratoga, the Adirondacks/Adirondack National Park, rafting on the Hudson river. I've done all of that except Niagara falls in the 2 years I've been up here. Downtown Saratoga has a nice nightlife as well.
I didn't like Goose Creek at all. I'm from a warm coastal area and it was like a crappier version of home. I was under 21 when I was there though.