we moved here from WI 2 winters ago and love it. Our neighborhood is on the lake, one thing we noticed ( in comparison to many of the lakes in WI anyhow ) is that it's not so much a matter of single homes on the lake but actually larger 'hoods. Many of which have their own boat access/launch ( a huge plus for us ). We actually are on the north side of the lake in the Chapin/Ballentine area, also known for their school districts. Drive time to the "mall" area is less then 20 mins and into Columbia maybe 30.
Coming from a suburb of Madison, we tried to find something similar down here; on or near a lake but close enough to the "city" for shopping/eating needs. We work from home so commuting is a non-issue, but we've both driven further in the past and the lack of winter makes any commute ( for a midwesterner ) much easier here; this was a relocation by choice for us.
Being near Cola gives us 2 big pluses we did not have in WI: that being the ocean is a 2 hr drive in one direction ( Charleston, also great for sightseeing ), and the mountains a couple hr drive in the other direction. If big city ammenities are needed that you can not find down here, then Charlotte is 2 hrs away as well. But this location has plenty to do for adults and kids, the zoo is great, there are some nice parks, the malls are nice ( hey, maybe they arent the MOA but what is! ), and being on the water in winter doesnt include drilling a hole thru 18" of ice to fish..
We came down for a week before our relocation, not only spent time with our realtor to learn more about the overall area, but we also did things we'd do if we were residents. That sold us.
Oh, and while last year had one storm with the 4th heaviest snowfall in history ( 8" +/- ) and this winter is one of the coldest ( along with a couple inches of snow from the 26th ), winter here is like fall in WI/MN. Just be ready for summer; long and hot. But with the lake close by, it is not a big deal.
Good luck with your search!