AFAIK only real sour lemon were the 1.4 petrol engines and those dual charged engines from the mid 00's. But around here everybody knows that only true VAG engine is a diesel. That is the folk lore around here not my own opinion.
I myself drive a Peugeot as for my tastes price/performance of VAG is not as good.
Personally I would steer away from Renault (had several, only "good" car was R4 :)), and basically any American brand. I think that in the value department Asian brands are giving European and US brands quite a run for ther money. Too bad they do not make a Berlingo/Caddy/Kangoo class of a car.
Even if VAG is total shit, dual charged engines are not something you would want in your vehicle. I think hybrids are a much better and simpler option.