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.
For things like this - unless it is something I am 100% sure of (i.e. I have something I can refer the person to), I usually qualify most information I give people by saying "but you might want to double check, just to be sure".