Not a foundation but heard this is SUPPER good if you wanna look tan so I'll recommend
Saie Glowy Super Gel | All-Over Luminizer | Clean Highlighter
Never tried this one out because of the price but many people say it's worth it
Hollywood Flawless Filter: Glow Booster - Charlotte Tilbury
Also not a foundation but bronze drops heard this is super good for a bronze or tan face
D-Bronzi™ Anti-Pollution Sunshine Drops | Bronzing Face Serum
Primer
I have this one and it's REALLY good I always tap into my skin instead of rubbing it in so it can get into my pores and it does hold my makeup for a good amount of time
Power Grip Primer + 4% Niacinamide | e.l.f. Cosmetics
Heard this one is really good from TikTok never tried it tho