I love my CX-7. Biggest consideration for a new owner is the gas mileage. Because of the different turbo inlet, it spools faster than the mazdaspeeds, so you're always in boost. Good for performance; gas mileage, not so much. That said, I still get about 19-20 mpg with mixed city/highway "spirited" driving. It is not a problem for me, but you will probably hear others saying it is worse for them.
Otherwise, no complaints. I love my car and couldn't see myself in any other suv/cuv or whatever you want to call them. If not for this, I'd probably be driving a legacy gt right now. Good luck either way...