FWIW if you want economy buy a 4 cyl diesel, you may or may not feel this suits the car - and I definitely see the attraction of a V6 Omega for wafting along but I bought my 2.2 DTi estate for the combination of space and relative economy, and so far not been disappointed.
Right now I'm showing 40.4 to 40.5 mpg on the t/c which I'm sure is not strictly accurate (I have checked and wasn't too far off) but I can definitely live with this given the space / comfort / equipment even in a lowly CD.
Not checked recently but I dare sat there is a premium for diesel - but you'll get that back on resale and enjoy fuel savings in the meantime if you can live with manual - and not the quickest journey times.
Got to agree, I use my DTi Elite for my daily work commute and when going on holiday etc and it's saving me a fortune over using the 3.2 Elite.
I worked out that based on fuel savings the price I paid for the DTi estate meant that it had paid for itself (purchase price) in 8 months. SWMBO now has the estate and because I was so impressed I went out and bought a DTi Saloon as a replacement.
Sadly the V6 doesn't get used quite as much now but maybe i'll get around to LPG'ing it and have the ability to use any of the common fuels available at the forecourt and just fillup with whatever the cheapest is that week!