I want one last great diesel estate car. What would you recommend as a simple option?

I drive 25,000 business miles per year and do not think battery-electric would be suitable for my next vehicle. I recently saw an advert for the advanced technology on an Audi diesel and it frightened...