I have mid 40's reasonably good skin, I love a full coverage but can't wear it like I used to as it looks too flat and shows up hollow areas (sigh).
I like Bourjois Healthy Mix (not serum) foundation and the Perfect 123 Foundation.
The Healthy Mix is medium coverage and builds well. I also find the shades are good for me as I have yellow not pink toned skin and I find they lean towards yellow.
The Perfect 123 foundation is full coverage and longer lasting.
I tried the Body Shop Clay foundation and liked it a lot but it's very matte and chalky. Sadly my 40+ skin can't take chalky foundation any more! Same for Estee Lauder. It looked like a mask on me. Too flat, even with pearlised highlighters on top.
I did love the Dior Foreverskin foundation but I was between shades and even mixing them didn't get the right results. Clarins Everlasting foundation was good but again, not really the perfect shade.
In summer I love the Touche Eclat foundation but it's too light wearing for winter.
Basically as I've got older the shade range is just as (if not more) important than the texture. What I really want is a full coverage yet radiance foundation in the perfect shade. I can get two out of three of those but I can't say I've found The One yet. (weeps)