The Google blog announced yesterday, in the spirit of the Olympics, they have "updated Google Earth and Google Local with high resolution imagery of the surrounding area." I was able to get as close as a 100 feet on Google Local Torino. If you have Google Earth installed, you can click here to zoom into Torino on your desktop. The Google Blog also links to Google Maps Mania Blog's Winter Olympics Google Maps Mashups with some cool uses of the Google Maps API and the Olympics.
Postscript: If you're looking for fast facts about the games and some cool databases, check Resource Shelf.