We had a Mazda MPV since the strollers wouldn't fit in my wife's Mercedes trunk. She VERY RELUCTANTLY traded the Benz for the MPV. the van was great. Practicality above all! And the Mazda was the sportiest of all Vans of its day (2002).
She traded the MPV for an 04 RX330 a year ago. My boys are now 4 and 8 so strollers are a thing of the past (wahoo!). I find the RX to be GREAT in terms of space. It's clearly smaller than the van in pure cargo capacity, but overall, the RX has MUCH bigger rear seat room for the kids than the van did. Yes, MORE room! And for those longer trips, I just throw my Thule box up top and instantly add 16cu ft of trunk space. That box, by the way, can fit strollers, pack n plays, and high chairs ALL AT ONE TIME. So for trips, it's great. But you don't want to be getting a stoller out of a roof box daily.
Now, that all being said, we are not happy with our RX because of how it drives. Electronic throttle and variable steering makes us both less than enthusiastic about the way it drives. It's really a shame too, because we find the size, looks, styling, etc, all great. And we got it used with the CPO 100k B2B warranty for a great price. Too bad we don't love it.
If you drive it, and love it, buy it. I would suggest borrowing it for the weekend or something from your dealer to make sure you really like driving it. maybe my wife and I both just like more of a driver's car than others do.