If you now rushed to click "reply" to say that yes, of course there is, right here, hold your horses. You probably do not understand the problem.
Good photo archival software would let me keep my photos in formats that will be readable 25 years from now. It must not rely on any company being in business or offering any service.
It must support storing the same picture in multiple formats. It must support assigning dates to pictures that are not the same as the file date nor the EXIF date. It must support assigning imprecise dates (just a year, or ideally an interval).
It must support storing multiple files as part of the same "image", and I do not mean multiple versions/formats of an image here. Examples: front and back of a scanned paper photo, or 24 scans of a large format picture that are then merged together into a resulting stitched image.
All that information must be preserved in ways that will let me recover it even without any software (e.g. files in the filesystem).
I used many solutions over the years, and got royally screwed by most, the most recent one being Apple shutting down Aperture (which did most of these things pretty well). I am now close to writing my own software.
EDIT: to all those who respond with "just store it as files" — yes, of course they should be stored as files. But that's not an answer. You do want searchability, nice visual access, and other niceties on top of the basic plumbing.