Interesting.
So it does sound like the downtown is revitalizing, maybe more than I thought!
I'm sure you're right about most of the neighborhoods, though. In the video, with so many missing houses, empty lots, and lack of businesses and overgrown foliage, it looked more like a semi-rural community than a major city!
But I'm cautiously optimistic about the future of Detroit.
Tearing down the excess housing is a good start, and if Detroit is like other industrial cities the first to move into the lofts and abandoned factories will be the artists. musicians, and others that require working or performing space. Then the young & hip start coming drawn to the creative artsy scene, and soon business that cater to the young & hip follow, and suburbanites eventual flow into the neighborhood on weekends dropping cash in local businesses. If that point can be hit, the neighborhoods usually succeed, since the young & hip eventually become less young, and have to deal with the pragmatic realities and needs of raising families - if, they don't abscond to the suburbs! That's a big if.
I've seen the above pattern occur quite a bit.
The other key will be the continued transition to a non-industrial economy, and that's obviously more difficult than in some other cities due to Detroit having been a bit of a one-trick pony ("The Motor City"). Sooner or later as the local economy continues to improve and the population continues to grow, those cleaned-up neighborhood will begin to make economic sense to some new residents,
I hope this continues and gets there, because I'm old enough to remember before the rise of L.A., the city mentioned in the same breath as "Chicago & New York", was always "Detroit" - not "L.A." It's ironic, because I just had this discussion about "CHGO-DET-NY" recently, where it was brought to my attention by a middle-aged gentlemen formerly of Detroit.