We have a direct injection turbo in my wife's honda and I love the motor, performance and mileage wise. The problem is I've already gone through injectors at only 120K. Honda took care of most of it though. Honda and Toyota typically take better care of customers when problems come up (from what my dealer clients have told me).
I can get 36 MPG on the road (have gotten 38 before) in our CRV which is pretty damn good for a non hybrid small suv. Has plenty of power and good torque curve with the turbo.