I do not believe there is any automated way to do this on Windows. A lot of these kinds of things pop up on the mac first, as Apple has a huge team that works on their bundle of little iApps like iPhoto. It is a critical part of their platform, and fancy little tools like that help their bottom line.

When it comes to the big dogs in the photo editing software industry (or rather, big dog), Adobe has to divide its attention. There are quite a few demands for specific features and improvements in Lightroom and Photoshop, and a feature that lets you create a slideshow that involves flying around a map zooming into photos isn't something that is commonly requested by the primary user base of those tools.

The simplest solution to what you are trying to do would likely be some kind of mashup with Google or Bing maps, an online photo service (Picasa, Flickr?), and a good chunk of time spent wrangling clever JavaScript and JQuery.

If I were to set off to achieve such a thing myself, I would resort to .NET 4, WPF and/or Silverlight 4, and some C# and XAML. Doing fancy 3D animations with a map and some photos is a perfect use of WPF's 3D and animation capabilities. Can't really say I could get it done in less than a few weeks, but it certainly isn't impossible to do.