Well, I have mixed feelings on the Vue. I'm a car junkie and I go and drive different cars all the time just to keep on top of what's out there. When the Vue first came out, I wasn't crazy about how it looked but when I finally saw a nice one with no ugly gray plastic on the bottom, I was quite impressed. Plus the fact that the Honda engine is available.
On the issue of resale value, I think newer vehicles tend to have better resale values than older ones, even of the same eventual resale value... if that makes any sense. I think on an AWD V6, you will lose about $9,000 to $10,000 in a couple years or 30,000 miles which is pretty bad in my opinion but certainly not as bad the really bad choices like the Taurus and the lower Hyundai and Kia products but I have no doubt that the Honda CRV will hold it's value a bit better.
Speaking of the CRV, it is probably the biggest and most direct competitor to the Vue. They are very similar size-size with some dimensions being bigger on one and some on the other. The biggest differences are probably the rear leg room and front hip room where the CRV is definately bigger on both counts. Also, the CRV has more cargo room whether the seats are folded up or down and in driving, the CRV feels quite a bit more nimble to me.
It sounds pretty one sided in favor of the CRV but in all honesty, if it was up to me, I would still VERY strongly consider the Vue. That V6 has almost 100 hore horsepower than the decent honda 4 and if you go easy on it, it still gets almost the same mileage. And it is rated to tow more than twice as much as the Honda. For an enthusiastic driver, the Vue with the V6 feels pretty darned nice in a straight line for an economical SUV.
I think overall, if I were going to buy a new one, I'd still be pretty tempted by the CRV but if looking at a used one, I'd try to find a single owner Vue that had good records. If recommending one to someone else, I'd probably suggest they drive both and look at the economics of both and go with whichever felt better but I'd absolutely suggest they spend at least a half hour in each of them and try to keep an open mind.