I grew up in a town in Italy where half the population still worked in agriculture, and the FIAT Panda[0] was insanely popular in the '80s, '90s and somewhat even now.
The '80s 4x4 version was basically perfect.
This to say: you do not need a huge modern SUV for non-metropolitan area.
Edit: I just realized there's an underlying issue: you can have more than one vehicle in a family, one larger for specific needs like long trips, and one small for daily usage. This seems to be the default in Europe these days.