I have a LWB renault trafic. Its at the limit for a supermarket car parking space, but a swb would be fine. I’m pretty sure a SWB would be shorter than the bigger 4x4s.
I get 35mpg plus, but that is mixed usage – longer trips with me bikes and boards and I can get over 40. I do take it easy with the right foot though.
You will need to fit something in the back for smaller loads, I have a couple of storage boxes, or it will rattke about – I’m thinking supermarket shopping.
The ride/drive is fine, a bit noisy, mainly the cheapo bulkhead rattling when empty in mine – but to be honest much more relaxing to drive than some of the hot hatches I used to drive with rock hard suspension and all.
…. But make sure you understand the servicing/maintenance costs and understand than the van may have had seen a bit of life before you got it. It may be that the previous owner is getting shut because expensive work on the way – engine belt, dual mass flywheel etc
and be careful when reversing