At 8.5 years old and 20-25,000 miles per year on each of the two main cars in my signature. Over 200,000 now on the Yeti - must update the sig.!
Then I'm sure a diesel remains the right choice for both me and SWMBO. And I'm thinking just as much about the CO2 emissions as much as mpg.
NOx are a subsidiary concern, as rain washes those out of the atmosphere fairly rapidly and they are very reactive, so breakdown into less noxious (appropriate word?) compounds easily - that's why AdBlue works. Whereas the higher levels of CO2 per mile emitted by petrol cars (in inverse proportion to their mpg) is of greater concern, as that stays around for centuries and destroys the planet. While the NOx just destroy the humans who are destroying the planet? (Incidentally, that is one of the things I agree with VW on, and why our Yeti will remain "unfixed". I'd rather keep the higher NOx and lower CO2 thanks).
The diesel engines themselves are still as reliable as ever. Its mainly the emissions gubbins attached that cause the problems. More recent DMFs, made to a stronger specification, seem to be much more durable. Two manufacturers supplied DMFs to the VW engine assembly lines. Sachs and LuK (a.k.a Schaeffler). There is much anecdotal evidence among the garage trade that the LuK units are more durable than the Sachs.
Petrol engine cars also have expensive catalytic converters that can and do fail. My last petrol BMW had a cat fail. It's brand new non-OEM cheapo replacement cost £250 and failed in under a year. Replaced that by risking a £350 second hand genuine cat from a breaker. That was fine! Till I sold the car 2.5 years later. (on 250,000 miles). New cat was £850+VAT list.
P.S. It's "dual" mass flywheels, not "pistols at dawn". Darn auto spell correct again no doubt! That has done nasty things to my posts several times.😉