A new cityscape generator from Video Copilot could save hours, if not years...
Here's a way to improve the look of your textures in 3D animation tools like Blender
Have a close look at this video clip. It’s an advert for a high-end kitchen worktop manufacturer. Watch it in 720p, and look as closely as you can at the camerawork, the clever use of depth of field, the lighting, and particularly the fresh fruit.
And then reflect on the fact that no cameras - or indeed fruit - were involved in the making of this at all.