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.
Forgot my old password somehow? (been a couple months since I last had something worthwile to say) But anywhoo...I haven't seen it mentioned here...I did make a post before somewhere..I figured I'd make it a top level post. if you want to..