I would think seriously about whether you need a diesel. Even Euro 4 (pre-AdBlue) have loads of sensors etc. that can (and do) fail as the car gets older, although not having a DPF would help. We have an OM642 V6 in a Vito (owned from new and FMBSH until recently) ... although the DPF itself hasn't been a problem the DPF pressure and two temperature sensors have gone (and the crankshaft position sensor, and the fuel pressure sensor, and the mass airflow sensor, and the EGR valve). These will all put you into limp mode. Ours also gets through glowplugs at an alarming rate (this started at 38k miles) - the plug relay and the 'mega fuse' for the glowplug circuit have failed too. More seriously we also had the exhaust manifold liners delaminate, trashing the turbo. This is a 'known issue', but relatively rare (seems to occur mostly in MLs). Yes we've probably been 'unlucky' to some extent but overall it's been the least reliable vehicle I've ever owned (and I started driving in the late '70s!).
We switched from diesel to petrol for our cars 10 years ago and currently have a C300. This gives 40-44 mpg on a decent run, which is fine for the amount of mileage we do. With 255 bhp it's decently quick too (0-60 in 5.5 secs). Did take a while to find a petrol one though.