As for automtics, they are very good for city and motorway driving. The stop start driving you get in cities is ideally suited to automatics especially as if you just take your foor off the brake it will "creep" along
On the motorway, they are relaxing to drive.
the only area that the manual box wins over is on winding country roads with the ability to change gear at the right time for corners, but then as the autos fitted to a 4X4, there isnt much "racing2 throiugh country lanes anyway, more a sedate trundle.
I have had both manual and auto 4x4's before and I always thought that for proper off roading, nothing could beat a manula box, but over the past few years, the land rover auto box has shown me that has changed, the crawling feature of an auto is very good on muddy conditions. Overall though if I was doing serious off roading then I would stick with a manual box I think (never get the time these days)