we have a Honda FRV - only has 6 seats, mind, so if you need 7 then no good - but we love it.
all 6 seats are permanent (3 in front, 3 in back) so no differing boot size according to passenger numbers.
It's the same size as an avarage car, so no hassle driving/parking.
all 6 seats are same size, so no big sear/small seat arguments, and fits car seats well - we recently had a rear facing infant isofix seat, and a RF isofix toddlerseat, with no compromise on driver/passenger legroom.
we regularly have dh, me, dsd (18), dss (16), d1 (nearly 4) and dd2 (17 months) in the car, a P&T +doubles in the boot, and a large (Rottie) dog too.
we have the 2.2 (I think) litre diesel, and it works out at around 42-45mpg so not brilliant, but certainly not the worst.