I'm at work right now so I can't go deep into Charlotte, but it depends on what type of person you are. I will say, no matter what, check out NoDa - in particular Red @ 28th and Amelies because the place is crazy diverse. You have your yuppies, hipsters, stuck-in-the 90's niccas, out-of-towners, cool kids, fashionistas, Nerds and just your regular niccas all in the same place on the weekend all chillin' and getting along Amelies is open 24/7. Then you can go up the street (biggest food landmark is Cabo fish taco) and hit the bars and coffee spots or just enjoy walking around the area. Noda is not big, but easily the most diverse place in Charlotte.
Southend is cool too, I don't have enough time to write another paragraph though...