3D Artist mzkam showed this realistic recreation of a twisted Lombard Street in San Francisco, presented as a loop animation.
The render was crafted with Houdini and Redshift, using RBD Car Rig, which converts oriented car geometry into a driveable dynamic car rig with constraints for the suspension and motors.
Also, check out this fantastic recreation of the Fontaine Saint-Michel in Paris by Scans Factory, an animation of an American neighborhood in Samet Dereli's Maple Drive by 3D Artist Samet Dereli, and a breakdown of creating a street environment by 3D Environment Artist Blayde Gilley: