I've recently found a site that caters to artists that create visualizations for architects. The examples seen on this site are what I hope to be able to produce in the coming months ( or maybe years? ) It's a cool place to look through whether you are interested in creating renderings and animations or not.
http://www.cgarchitect.com/
There are more renderings than animations here but those animations are pretty good.
This one is one of the better examples.
Take a look for yourself. It's pretty amazing. It's not of Detroit but still amazing.