My bmw 120d was fantastic for economy, 48-50 real world mpg all year round and remapped to 210+bhp. Even if I drove it like an idiot it would still do 42mpg.
However, sounded awful, 1st gear was pointless and when I felt like a spirited drive although the torque was bloody impressive it was no fun.
Petrol all the way for me now purely for the fun factor