I think the real horror stories are about the 1.6 TDCi with the CVT auto. This was only available for about 18 months, and Ford perhaps realised it was a disaster - given what I've read (remembering internet is usually dominated by extreme positive or negative experiences), I'd get a different MPV than have one of these.
Isn't there now a 2L TDCI with a powershift twin-clutch auto? (like the DSG boxes in VWs) This would be recent quite new so I expect there's not much operational info yet.
Not sure on petrol auto options - I think there's a 2L version, and my mate's got a 1.8 auto, but he lives in Netherlands so I don't know if that's ever been sold here.