Thanks all, very interesting comments and much in alignment with my own thinking.
Our location dictates a 4x4 is required (long (400m) , very steep (20%+), very bumpy, prone to frost/ice). My immediate neighbour, with whom I share the drive, has an ancient ratted Defender and a 4x4 Tiguan. He says he needs 4x4 and I believe him.
Deffo don’t want a DSG gearbox, I’ve never liked auto, or semi-auto. Noisier, clunkier, thirstier, less reliable. I’ve never understood the appeal. I much prefer manual. My wife is off the same opinion.
All season tyres will be fitted as sensible opportunity arises.
And, yep, I think I’ll go for petrol. Autotrader here I come!