If you are looking for some fuel economy, good handling, inside comfort and nice manufacturing, not looking to tow anything with it, I encourage you to look at the Rogue.
This car was made with that category of people in mind (older people with no more kids to take care of (except sometimes grand children?)).
It has great ratings in safety (original design by Renault (based on the Megane)) and really comfy when you sit inside.
The first ones are getting out of lease, so you should get some good deals. And the mid life refresh is out for 2011, so it should decrease the value of the first ones.
If you go for an used one, check for the CVT transmission: If it has been changed or make some noise when decelerating from about 50mph (foot out of the throttle fast), don't get it, you will have problems with the transmission (again if it has been changed). If the car is clean in that aspect, go buy in confidence, that is basically the only problem you could have with this car.
Out of that CUV, I would look at the Forester, the CR-V, the Outlander, and the RAV-4.
I looked at all of them, but at the end, I chose the Rogue.
Go test drive it before rejecting it, a lot of people were surprised how good it is (a lot bought it after a test drive).
Have fun experimenting.