The one I'm most familiar with is Raleigh's Fayetteville St. area. It was renovated a few years ago to go back to a street + sidewalk configuration, and has really had a renaissance, with nightlife and people living downtown.

Before, it looked like this:

http://goodnightraleigh.com/uploaded_images/fayetteville-st-...