Create an Awesome 3D Future City
This is an extensive tutorial which focuses on modelling, using the plugin Greeble to add small amounts of detail to the buildings, and finally texturing lighting and then post production in photoshop. The instructions are reasonably easy to follow but be warned it takes a beastly computer to handle it, I think my final scene was at about 250,000 polygons. You'll also need Vray which you can just download if you don't have.
The final result is pretty amazing but it can really bog down your hardware, I had quite a few crashes with max untill I found out how to set things up properly. My first estimated render time was 108 hours! Mainly because I'd made a mess of the vray settings. I think my final version took about 20 minutes.
7/10, not great for a beginner user, even though it is step by step.