I have schizophrenic skin and I have periods where I don't seem to need foundation at all and periods (usually under a little stress) that I need good coverage, yet the skin could look worse with less than optimum quality make up.
I find that usually creamy, thick and buttery feeling make up works really well for me. When I break out, my pores seem to elevate and get all gross too and the wrong make up consistency can make it appear worse. I always use a silicone primer because the lotion ones don't seem to work for me aside from being a nice lotion for the face. Take into mind that I have combination skin and I don't sweat much at all, so my results may be a little different from yours.
With that in mind, I really like:
~ Revlon Colorstay oil-free
~ Dior Icone Perfect creme-to-powder
~ Make up Forever Mat Velvet (this one is a little more liquidy and thin than the other two, but it stays absolutely matte. I'm not into the dewy/glowy)
~ CK Calvin Klein Infinite Fusion (really nice and silky on me, but some people don't like it)
~ Neutrogena Clear Skin Cream compact
A couple of ones that are pretty good, but not favorites:
~ Bare Essentials (this doesn't seem to cover much and it's just way too many little jars and pieces for just the face. Do I bring it? Do I leave it at home? ACK!)
~ MAC Studio fix (It is alright on me, but it isn't matte after a few hours and a couple of times I found myself with blackening pores...)
~ Chanel Double Perfection Compact (Good coverage and fairly matte, but it kind of smells and is not as velvety as the CK one)
~ Loreal Infallible liquid (It's too moist for me)