I've noticed it's the people in the suburbs who are usually pessimistic about downtown. I've been living here the past two years and it has been a blast. No one here is "waiting for a revival." It's already pretty awesome. I have no doubt these plans will make it better.
Here is the view from my apartment and you can see the lots along Woodward where the stadium will stand. You can see the FOX theater sign for a point of reference. I'll post more pictures once they start construction.
There are nice areas downtown no doubt. the problem is that there is almost the same amount of bad parts as well. Detroit is one of the largest cities in the country in terms of square miles, yet they are one of the only few cities to have a shrinking population. The city was built for a population of 2 million, not 600K. As a result you have a ton of areas that look like post apocalyptic war zone. They need to demolish these abandon neighborhoods and consolidate the city (easier said then done i know). but the city as is too big for the population that it has right now