If you have a Mac with iPhoto 7 or Aperture 2 (or newer), the experience is hard to beat.

WSJ: The Best Design-It-Yourself Albums

The iPhoto app, bundled gratis with every OS X-based Mac, touts a 'Places' section that automatically recognizes standardized geolocation data in photos.

ENGADGET: Embracing geotagging: how to journal your trips (and contribute to Google Earth) with snapshots