We are still very pleased with our Kia Sportage. It's not massively bigger than our old hatchback, mainly the height and it doesn't take too long to learn the handling compared to a normal car. In fact I'm quite addicted to the heavier driving feel and looking forward to longer trips in the summer.
It also comes with a 7 year warranty and a 5 year service pack can be purchased quite reasonably.
My main caveat/advice based on experience to date is, if the budget permits, buy one with a rear parking camera/sensor. The height and shape means rear visibility not that brilliant, though possibly something that applies to other SUV's/compact SUV's too.