Lake Norman, is quite pricey, even compared to other high price areas - think Nascar racers, drag racers, and their bosses. Houses are really nice, but for a $1M you get more bang for your buck elsewhere. There is at least one restaurant of every chain you can think of, and quite a few one offs - if eating out is your bag. They have their own West Marine and most power boat dealers are well represented. There used to be a couple of sail boat brokers on the lake (4-5 years ago, not sure now), but it is a power boat/jet ski crowd for the most part.
If you live off the lake, not waterfront, there are many "yacht" clubs, most social in nature, but many have their quirks and you may or may not feel "at home". Some are fairly exclusive. They too can be pricey, depending on what you are used to.
While there is plenty of shoreline, sailing is OK - during the week and if the weather works with you. The weekends are a night mare to sail on, just too many people doing too many stupid things. The traffic in and out of the area can be a chore, so plan accordingly, you can sit for quite a while on weekends. The shoreline has receded some a few years back, not sure why as it is an impoundment for power generation and is the largest manmade body of water in NC.
I guess it boils down to how you want to spend your retirement. I would go to Smith Mtn Lake in VA, or where we will retire - the Northern Neck of VA - that puts you about 10-20 minutes from the bay and all the sailing you can handle.
You can visit and see most of the important stuff in a day or so. I would plan on a weekday and a weekend day...so you can see how things change.