The newest version of Google Earth includes 3-D photorealistic buildings, sunlight (with shadows on those realistic 3-D buildings), and a Spiderman-esque swooping action. Here's a "photo" I snapped of downtown San Francisco.
You can just see the 3-D photorealistic Golden Gate Bridge peeking up in the background. See some more examples at Google's LatLong blog.