I can only say what we have, an old battered Honda Jazz, a Jaguar XE two wheel drive model, and a Kia Sorento. OK Jag is wife's I am not allowed to touch it, and the Kia Sorento is for pulling the caravan, so in real terms we are using a rather old Honda Jazz.
If we visit brother-in-law then Kia Sorento as he has a long unmade road to house, but the snow is no worse than when I worked at Sizewell 'B' there is in the main no need for a special car, yes loads of people do run around with 4 x 4 vehicles, but Chelsea has so many they are called Chelsea tractors, it's not the weather it's the keeping up with the Joneses and we do have one or two of them, not sure where they came from no J in Welsh alphabet so clearly not Welsh.
There are steep roads, but in Wales in the main roads go around the hills, unlike the South of England where they just go over hills, so on average likely less need for 4 x 4 in Wales than in England. Also we are a bit more laid back, if it does snow hard, cure is simple, stay at home.
Likely the best car for Wales was the Morris Minor, upright loads of ground clearance, and rear wheel drive. However the Agila
was similar shape and size, but in real terms the Yaris
worked out a lot better, it is not always what we think will work best, the wheels were too small on old Agila, yet it was the thin wheels on the Morris Minor which allowed it to grip.
However any small car has less over hang front and rear so less change of grounding, this
is useless, I bang my head getting in and out, and have to wait until out of drive or it grounds, but wife loves it, so just have to wear a hat, and once in it on the road it's great, and there is a 4 x 4 version, but I would be able to get more in the Agila with seats down than ever in the Jag, although the Yaris boot was rather small, however I used them all in Mid Wales, so yes this
looks good, and is a 4 x 4 but it is so wide and with manual you have to play tunes on the gear box to get reasonable MPG so unless towing trailer I still use the old Honda Jazz. Oh yes with some models of the Sorento you have to change all tyres together or it will keep engaging to auto 4 wheel drive.