For finding people across hundreds of thousands of photos, I use snapbyface.com regularly. It runs completely offline on my computer, scans folders, and matches faces from a single reference photo. The theme detection and auto movie creation might still be a stretch for one local program, but snapbyface handles the people side well, and you can export matches to build those birthday compilations yourself.