I have been searching for my Holy Grail of foundations! I’ve found it in Mac Pro Longwear Foundation.
It literally lasts a minimum of 16 hours, without oxidising. It looks freshly applied throughout the day. You would not even have to use powder to set it when applying.

I have very oily skin and have only ever used top name foundations. By 12:00 I look exhausted and my foundation looks “tired” and has oxidised. I usually need to use blotting paper to soak up the excessive oil.

With this foundation, none of this happens. My skin looks fresh the whole day; I never need blotting paper any more. The coverage is medium to well. It isn’t “cakey” whatsoever. It doesn’t settle in fine lines. It’s perfect in the sense of not being matte, but not being luminous either.