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.
The opening was great. I liked the kids show/girl hitting puberty segment. Any time you get a guy in a kids show dinosaur outfit smoking and being surly it will always get a laugh out of me. The Hangman was really funny as well.