iPhoto is a pretty great photo management app, although hampered by Apple’s need to control your options on what you do with the photos.
Migration Score
GOOD
Migration Options
F-Spot
A great open source photo management app with extensibility built-in.