Examples of Automatic 3D reconstructions from photographs
paulbourke.net
paulbourke.net
Note that the switchcam startup mentioned in the other comment is almost completely manual right now, and is more about assembling a "director's cut" version of a concert video, rather than creating 3d. This actually seems more useful to me (although of course more automation would be nice).
What's the takeaway message?
I'd like to play with using a Kinect or simular 'depth camera', it might give better results.