I get to see tons of software in my weekly travels, and that includes photo management software. Picasa, from Google, remains my favorite photo management and downloading system for Windows, Macintosh, AND Linux (Ubuntu). It offers:
Great flexibility in organizing and tagging photos
Easy to use download function
Good integration with online photo ordering services
Wonderful way to share photos via online albums, Facebook...