[maxerickson]

Windows Live Photo Gallery got this more right than anything else I've seen.

You could filter by folder and display by date, or ignore folders and filter by date. And it had an easy UI for filtering by tags (that were pulled from photo metadata, not stored in an internal database).

(I suppose I bring it up because it worked well enough to make manually fiddling with sorting photos mostly uninteresting)