Only buy a diesel if you do a lot of motorway miles - diesels hate town-driving even more than petrol engines.
After two oil-changes, new plugs and some seriously hard driving to de-gunge the engine, my 'new' Cougar is now getting close to what my old one was getting on the motorway - about 35mpg on runs over an hour (against a personal best of 37mpg in the old one).
Around town it's significantly less of course, but from what I hear, the 2.0 is a gutless pile of poo at the best of times - which sounds harsh, considering the V6 isn't that pokey either: a new 1.8 S-Max will thrash the socks off a Cougar any day of the week (my mother-in-law has one for running the dogs around and I gave it a quick 'spirited drive' the other day - far, far better than the Cougar in all respects - apart from looks, obviously).
You have to accept the trade-off for owning a 13-year old car (with an almost 20 year old engine design): it's not as quick and it's not as efficient as anything on the market today in the same range.