I've had 7 years in a Citroen Grand Picasso which has been a great family workhorse but as boring as f*ck to drive. Preferred it to the Zafira the other half ran for a number of years.
I'd be wary of going to a car supermarket type place - their staff tend to be very hard sell and you'll feel...