Had one a few years ago
Pros:
Fun to drive
Felt good about it getting good gas milage
If you need to haul something, like IKEA furniture, or, in my case, a HUGE snow blower that I picked up from Sears, the 3rd row and middle seats fold all the way down, so you can really put a lot into it
Cons:
Not that great in the snow/ice. I never spun our or anything, but sometimes had trouble starting from a stop in an icy intersection.
Not very practical if you actually need to put an adult into the 3rd row--OUCH!!!
Can only accomodate 2 carseats--we needed 3, so we switched to a VW Routan when I was pregnant with baby #3.
ETA: We had the higher end model, the Grand Touring, and, brand new, it was about $22k.
We got ours from the Autobarn Mazda dealer in Countryside.