Depends what you mainly use the car for, If you do a lot of long runs you can get good MPG and a more relaxed drive with a larger engine and pretty good local MPG too, but the temptation is to use the extra power - and bang goes your fuel economy.
I think the Jazz is a good compromise between good everyday MPG and being a reasonable car for longer journeys. I have had five adults in the GD and it copes pretty well if you keep it between 2000 and 3,500 rpm. (peak torque is around 2,700). and lets face it, the gearbox is a joy to use, but surprisingly you don't really have to change gear that much to make pretty good progress. I almost bought another Civic to replace my 1.5 VTEC Civic, but having driven my wifes Jazz and seeing how good it was to drive and the fuel economy (with one eye on rising fuel prices) I bought a Jazz and have never regretted it.