Hello A.,
We purchased the '08 Mazda 5 Touring last June and I really have had a great experience with it thus far.
PRO: MPG - I average around 23 mpg, with the majority of my driving being on local roads-- about 60-80 miles each tank of gas goes to hwy driving.
PRO: Sliding side doors - just like the convenience of a minivan
PRO: Small and extremely easy to park
PRO: Zoom Zoom!! Very zippy for its little size and very manueverable
PRO: Optional 3rd row - gives us versatility when needed, although doesn't help us much for the times when my 6'4" brothers fly in from out of town--once baby #2 is born we won't be able to take any adult sized passengers with us.
PRO: Convenient storage/cup holders that flips out from under the middle seats -- great for sippy cups, books, toys, wipes...
PRO: With the 3rd row down, I am able to put my Graco Dou Glide (double stroller) in quite easily and still have a bit of room for groceries, etc. Also, I was able to put an in-the-box snowblower in the back of the car by having both the 2nd and 3rd rows folded down. The guy at Sears was SHOCKED that it fit in there! (And so was I.)
CONS: There is a fan that blows air to the 2nd row, however it is only cold air. Not sure why they didn't think that people would want their kids to have HEAT in the back.
CONS: Not sure that there would be enough room for us to have 2 kids on a road trip. Luggage might be tight, especially if we have the stroller with us.
CONS: Probably will not work for us once we have a 3rd child... so for us, we'll probably have it only another 3-4 years.
CONS: Not the BEST on the snow, but adequate for those times when I did need to venture out in inclement weather.
Overall - a great car if you have 2 little ones and don't do a whole lot of loading up your car.