I like digikam. I don't know how many of your requirements it passes. Opensource suite built on top of imagemagick.