Nothing knowlegable to add, apart from our personal preferences. I have a Passat 2L diesel, my partner has a Renault Captur 1.5L diesel. My engine is much nicer to drive, loads of torque, gets 46mpg around town and nearly 60 on a run. The DPF issue can be worked around by doing a longer run every week or so, or when the DPF light comes on. Sometimes it clears with 15 mins of motorway driving. A minor inconvenience and a bit of wasted fuel if you weren't making a trip anyway, but worth it IMHO. But the passat is quite low down to drive. On the other hand, the Captur is higher up, a much better city car, is a hatchback so lots of room with seats down, and is mildly better MPG but very slow compared to the 2.0 D. But once you get used to any car, I find you are not normally comparing performance to other cars that you don't own.
We're looking at part ex-ing both of ours and getting 1 slightly newer car. We like the "crossover" cars like the Pug 3008 and VW T-Roc but the newer ones are out of our price range at the moment. They look roomy and higher up but not as long as an estate. Plus my partner is 5'11" and we have 6" boys and there always seems more headroom in one of these compared to a motorway saloon.
Petrols are ok but the few I've driven in recent years were small cars, so were asking to be revved, and I was changing gears a lot more