I use Double Wear, too. It's great... but it's also quite thick and so it can look a bit dull.
They do a double wear light, which my sister has just bought. It's almost like a tinted moisturiser, but still gives the coverage of a foundation.
I don't think Estee Lauder foundations are the best for looking "dewy".
I sometimes use MAC, but again these can be quite thick.
When I've changed my foundation in the past, I've often found the cheaper makes (compared to Estee Lauder) to be a lot less "cakey" and therefore more fresh looking.
I recently used one by 'Soap and Glory', called 'Good Face' (?) and it was really light and fresh, and also had a built-in primer. You can get that from Boots, too.
:-)