Best value is to buy a new leftover model when model years turnover.I have seen used units priced high and used loans usually have higher interest rates than new. I drive my cars 200k, so I always buy new.

As for which one, if you have small kids and are concerned about mileage, then go with a CX-5. They are great.

Although 4 adults will fit in a CX-5, it will get bogged down with the extra weight. A CX-9 makes sense here, but you will sacrifice mileage and parking will be tougher. You can also look at a Toyota Highlander which is a great SUV in the same class.