Hi Sally
We've had a Nissan Terrano II 2.7 TD since new in 1995. We've been very pleased with it as an all round family vehicle and towcar. We currently tow a 5 birth Sterling Europa, and it's steady as a rock. It'll sit all day at the legal limit. There's 4 of us plus a dog in the passenger area, and in the boot we carry a full awning, folding chairs & tables, food, jackets, drinks and much more. Once on site, if you want to go out with friends then the third row of seats makes it into a 7 seater. No Problem. You also know that you're not going to get stuck on a muddy pitch. One of the great advantages we've found with a 4x4, and it would also apply to many MPVs, is the fact that you sit high up. You can therefore see over hedges and walls and enjoy more scenery. Sitting in a queue is also less stressful as you can see over the other cars.
The only downside that we've found is the mpg, which drops into the teens when towing. I'd certainly have another one if I had the money. But I'm not planning on changing it for a few years yet.
We also own a Corsa, but both my wife and I prefer the driving position of the Terrano.