DH says you probably want Adobe Lightroom. It's a pro tool, so it's not cheap, but he doesn't think ACDSee will handle an archive as large as yours...

He says there are already betas out of image recognition software, where you'll be able to tag an image of someone (or some object) and have the software put the same tag on all your other images of that person or thing.