For photos, you're going to want a foundation that doesn't have a ton of reflective particles or a high oil content. That way, you don't end up with a weird “ghost' effect from the camera flash bouncing off your makeup. Generally, any product that advertises itself as “HD' is a safe choice, since it will have been specifically designed for on-camera wear. The original (and most widely used) product in the category is Smashbox Liquid Halo HD Foundation. Their entire HD line is pretty reliable and worth the investment, though, so if you prefer powder or cream foundation, give the rest of the collection a look.
Alternatively, Sunday Riley Liquid Light Color Correcting Luminous HD Foundation feels airy and the color correction is much appreciated when you're breaking out or experiencing winter redness. If you want one-stop does literally everything makeup-skincare insanity, though, Stila Stay All Day 10-in-1 HD Beauty Balm is your ideal item. It's made for photos, but also probably other situations; we would't be surprised if it removed red wine stains and had an inflatable raft inside, too.