The modern automatics arent that bad, they will also deliver a very sporty ride if you wish. I dont really think the M6 is that special, for that money I would be for sure go shopping elsewhere.
Here a nice little Top Gear clip on the diesel vs petrol thing demonstrated with a 5 series:
enjoy!