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.