NASCAR allows only four-speed manual transmissions. State-of-the-art race cars like the Formula Ones have used automatics for years.
However you will also note that F-1 eliminated electronic driver aids like anti-lock brakes and traction control because they wanted to make the driver a larger element of the sport.