We're in the market for a new-to-us vehicle.
We have one & we really love it. DH did a TON of research on what vehicle would be the safest/most fuel efficient in our price range.
Size wise if you have the 3rd row seat it is pretty cramped back there but I think that goes without saying. For cargo room it's good. We can fit quite a bit of stuff in the back. It has a ton of headroom (my Dad who is over 6ft was really comfortable riding in it)and the seats are quite comfy too.
As far as the comfort/ride it is nice, nothing fancy mind you but it's solid. My car before this was a volvo v-40 sport wagon so I was spoiled by amazing handling. The Rondo handles like your basic midsized car.
We get about 27 MPG on average & with the safety features and the warranty it makes it a really good deal.
I have heard that if you don't get a V6, it sorely lacks in the power department though.
All in all we really love ours! Good luck with your decision.