foundation/skin help

So I have dry skin and not very good  complexion rn (stress, college, coffee, sugar etc) and I've tried so many foundations. Plus I'm super pale and can't seem to find my match-they're usually too warm-toned. I've tried L'Oréal true match, reckons colorstay, blah blah blah it all goes on pasty and patchy (it blends okay but it dries pasty). It usually looks more flaky than this, too. I just want a nice glowy moisturized finish, that ACTUALLY covers my pimples.