Old member lurking...don't flame me....
I have the Hyundai Tuscon and love, love, love it! The ride is very smooth and 'car like', however it handles very well in bad weather. The transition to AWD is very easy. The interior is very spacious and it's good on gas.
I have a friend who has the CX5 and she likes it as well. I have been in her vehicle and it seems spacious and it's a smooth ride.
Other posters mentioned the Honda CRV and the Ford Edge. I test drove both and didn't care for either. The Edge (IMO) was a complete match up with the Tucson, so I couldn't justify spending thousands more. It just wasn't worth it and didn't make sense. I also thought the CRV was smaller and I felt more 'closed in' when driving.
ETA...The 100k warranty on the Tucson is a plus as well.