...The Mazda5 was on our short list until we had a chance to test-drive the manual transmission version, at which point it became the only choice. Seriously fun, while meeting all other criteria.
With regard to the manual transmission, just keep in mind that it will get several miles per gallon
less than the automatics at interstate speeds (70 to 75 mph) – that’s because they are geared lower than the automatics, so fifth gear is what fourth gear is in any other manual transmission car. Think 3,000 RPMs at 65 mph in fifth gear. Yes, I know that it’s rated as having a higher highway mileage than the automatic, that’s because the average speed in the EPA’s highway test is 48 mph but in the real world and on the interstate, the automatic will get better mileage.
Then again, the manual transmission really is fun to drive and saves you about $1,000 up front, and you should get better in-town / highway (not interstate) mileage.
As far as the other vehicles I had considered, it was basically between the Mazda5 and another sedan (probably a Honda Accord). In the end I wanted something besides a second sedan, and the Mazda5 offered car like driving, good mileage, great looks, the capability of holding more than five, great prices, and yes, manual transmission.
And the price after incentives can be really reasonable - to make a long story short, after all taxes, title & license, fees, etc I paid $18,000 for my '09 Sport with 3 years of 0% financing and no money down.