Riya's face recognition technology allows automatic tagging of your photos. According to their website, Riya can recognize & tag faces, signs and events.
The software looks damn cool. It is rumored that Google has expressed an interest in acquiring the company.
Beyond home users, this kind of automatic face recognition software would be a big help to organizations like Interpol, CIA, FBI etc. Or maybe they probably already have such software available.