Issues:
The only REAL downside for me has been the radio (which I took care of by going aftermarket) and gas mileage, which I knew ahead of time. If you want 30 or more MPG and don't want to fill up with premium gas, don't even look at this car. I'm lucky to get 20-22 on the highway, but 17-18 is really typical. Luckily, I don't have a long commute each day.
Im not being real picky here, but, who expects 30+ MPG out of a car when they go car shopping? the list for 30+ mpg cars is quite small, im sure people considering an SUV (short of a hybrid model or one of those Yaris things) is not even expecting close to 30. i think if u r averging 17-18 mpg in the cx-7, you are on top of the game.
my biggest gripe about the car (non mechanical) is that the back seat is like the land that god forgot. there is just ZERO going on back there, no details, no trim, no cubbys, just nothing, they need to get some action going back there whether it be some nice door handles or what not.
I will say what i now miss greatly from the MAzda is the roll out and quickly removeable cargo cover! that things was great - i never knew how much that thing mattered until i got the RDX with this stupid tether-secured shelf that is just almost always in the way of what i want to do back there and is a pain. and, it rattles and makes noise.