A little more than 2 years ago, after I found out we were having twins, I sold our 6 month old (bought used) '06 Matrix and bought an '07 Mazda 5 GT... and we have a 92 civic hatch! I do miss the handling and better gas mileage of the Matrix, but the Mazda 5 does handle pretty well, it's close actually, which is saying a lot considering how much heavier, bigger and longer it is than the Matrix. I've found many owners here will talk endlessly about how amazing it handles.... Honestly, don't expect much... especially coming from a Matrix and an older Civic. Don't get me wrong, it does handle great... for it's size and compared with other mini-vans, SUV's and crossovers.
The other advice has been good so far, I have an '07. At the time I couldn't afford an '08... would have liked to get that 5 speed auto. Getting a stick would have been even better... but after driving it for awhile and realizing it's really just our "cruising with the kids mobile" and... it is a big heavy van... I don't miss either. And since it sounds like your ride will serve a similar purpose, you don't really have to worry about trying to find a stick because you think it'll be more "sporty". That ship has sailed my friend

.
Make sure you have it inspected before you buy... as everyone will attest on this site, the main weakness of the 5 is it's original suspension, or suspension replaced with original parts... The shocks suck and will blow frequently if not replaced with something aftermarket. Fortunately, if you don't care about lowering or upgrading/tuning, you can buy replacement Munroe or KYB branded shocks and struts relatively cheaply. So when looking at vehicles, make sure you ask questions about the suspension and tell whoever is doing the inspection to look carefully at the shocks and struts, to tell you what brand they are, and that they are a know weak point on the vehicle.
Also the front and rear sway-bar bushings wear very quickly and can lead to a "clunking" in the suspension. The bushings are very cheap and easy to replace on the rear, but a bit of a PIA to replace up front... something else to ask about and for the inspector to have a good look at.