I've had two, both 3.0 petrol auto's both 2001 and both had gearbox faults.
Even driving fairly steady round town I still only averaged 19 mpg.
One was a normal spec and the other was a sport, the sport was nicer for me, they did not feel like they had 200+ bhp I found them fairly sedate but they were lovely to drive.
I would definitely look for a manual if I ever got the urge to buy another.