I'll echo the bits as dispensed by Alex ^^^^
Except for the blowing up turbo bit. Ive had an 07 one for the last 18months, with now 94k miles, having driven it 32k miles since buying it and overall I'm really pleased. Towing a twin axle plant type trailer is easy, in fact, the extra weight makes it feel more settled. Boggy, snowy surfaces/fields are dealt with happily. Function over form in terms of interior feel, but for me thats fine as it hauls my tools and materials around with me on a daily basis, so utilitarian and hard wearing does me fine.
Its reliable, relatively cheap to service, it does indeed like front brakes, and the 2.2dci doesn't return as much fuel economy as I was hoping, having said that, its about 35 - 38mpg average at a guess - it is what it is. Drove it down to the South of France last year and it was fine, happily sit at 70 - 80mph all day and some of the night.
I was also considering either the Subaru Forester or Outback diesel's and whilst they are very nice, they were more money for similar mileage and more car-ish inside, i.e. I wouldn't have been so keen to put tools and machinery and materials into them and I wanted something that could act as a works van and family motor at the same time and the XTrail does this with ease, also swallows bikes, camping kit and furniture with aplomb. Bit like my old 2.4 10v 850 estate, but more versatile