I use Revlon Colorstay foundation. It covers really well and stays on all day. I save $$$ for really good cosmetics for eyeshadow and lipstick, as I find colors are more up to date.
I have worked as a freelance makeup artist for Estee Lauder for the past 7 years and the BEST foundation for what you want is Double Wear. If it seems too heavy, try the Double Wear Light. I also worked for Bobbi Brown for a short time and did not like any of their foundations.