We've got a Range Rover Sport and I absolutely love it! It's a bit bigger than the Freelander, and to be honest I don't find it too horrific for fuel consumption so I'd imagine the Freelander would be even better.
Ours is also automatic, and I can honestly say now that I'd never go back to...