I've never owned an automatic. But I suspect that a modern, I emphasise modern, automatic would be best for anything other than trackdays or Mulholland (lol). I've heard they are even being used in some quarter mile type cars successfully.
Maybe I'm just getting old