Limited experience to date with the X-Trail here, having bought a diesel 2.2 07 model (mk1 I guess) a couple of weeks ago and covered about 1000 miles so far.
I like it. But I would say that.
Easy to drive, engine has good torque and the 4WD has worked well when needed. It’s pulled a semi-loaded 8×4 twin axle mini-digger type trailer with ease. Very smooth at motorway cruising and it really does handle more like a car rather than a boat.
I have the Columbia option, so no leather, but well equipped with sat nav, a/c, elec windows yadda yadda. The interior is ideal for me to double up as a mobile tool/workshop duties in the week with seats folded (big wide load area with no lip) and seats up at weekends for family stuff.
Given it’s design spec, it handles really well, not much body roll, steering has feedback and suspension seems to have been thought out well too.
The Renault diesel engine and 6-speed box are good – reports of dodgy dual-mass flywheels abound, but AFAIK, they were limited to 03/04 models but it could be anyone’s guess/luck of the draw on that one.
From my research, it boiled down to either the RAV4 or the X-Trail, but I needed reliable 4WD and towing capability and also didnt fancy the image I have of the RAV4 as a ‘hairdresser’s’ car.
The reason I didnt pursue the Honda was towing ability.
I’m sure both would be a good option. Hope this helps