I only go down there once a year for work now, so I'm sure others will have better answers than me, but if you want to spend the money, The US National Whitewater Center (usnwc.org) is a fun place to go. They have different packages there that you can purchase. Good way to kill a half day.
And I don't know any soul food places in Charlotte but if you like BBQ, then Mac's (macspeedshop.com) is pretty decent.
Until last week I had never heard of The Better Show but then I got a call and was asked to come on to talk about my Southwestern Turkey Soup recipe on allrecipes.com - the segment aired today http://www.better.