I love the new L'Oreal Paris "Magic Smooth Souffle" foundation. It's very buildable but goes on light as air. The only problem is that it isn't the best foundation for dry skin. It tends to seem very flaky if the skin isn't completely smooth. I suggest if you do try this, you gently exfoliate before using it, and then using a primer of some sort. (L'Oreal's new face base is awesome!)
Whichever foundation you decide to try, I suggest you buy it at a place where they will let you return it if you don't like how it looks and feels OR a place where you can try it out first. Retail stores like CVS and Walmart will take a return for used makeup no questions asked. Sephora stores and mail orders will do returns as well. And higher end department stores of course have the opportunity to try them too.
If you think you want to go with a mineral foundation, try one that is 100% pure. I use LA Minerals which comes in several different shades and formulas. They have a great deal where you buy 5 samples and you get 5 free!! You can find them at www.laminerals.com When my skin is slightly irritated from windburn or a break out, or when I don't need a really "creamy" foundation, I use my minerals. Even when I go out at night for an evening of dancing, I will put a light cover of the mineral OVER my L'Oreal for super-long wearing!
Good luck with your search!