I love the Honda CRV. I bought mine new but it is now 5 years old and still runs great. I have an 05, and that year they were best in class (or whatever car term is used) for the small crossover SUV's. They usually are. I don't know about every year, but they are pretty frequently, including this year. I didn't look at a Mazda but compared Rav 4's and CRV's and a few others, and the Honda was better all around, hands down. It is a smaller SUV, but you can tell that just looking at it, and bigger than the Rav4 I believe. I had a hard time bringing home a crib (disassembled in box) in it, but for your average stuff, everything fits great. 2 carseats plus a person across the back is not really going to happen though. It gets the best gas mileage of the class as well. Well, my year did. And has the best resale value. I used MSN Autos comparison tool to do some of my research, as well as consumer reports.
My only complaints on it are that it is a little loud for road noise (again, my year is, they may have changed that). But getting a little better quality tires when I had to replace them really helped that. And the hatch that opens sideways opens backwards, it seems like to me. I think it should swing from the other side. I honestly think those are my only 2 complaints.