Downtown has seen quite a revitalization in the past few years. Brightleaf Square is now hopping, The Federal and James Joyce are packed most nights (until 11 or so). The area across the street from Southpoint mall is complete and there's lots of shopping in that area. The American Tobacco trail is more complete than it was a few years ago (though it's still not done).
The American Tobacco campus is also a great place to hang out. Mellow Mushroom, Tyler's, WUNC and their summer concerts are in full swing. I don't know if the Bulls ballpark was done when you were last here, but it's a fun time for families.
Things really are moving in the right direction over here.