it depends on the type of racing. for high end drag racing, an auto is consistent and can be programmed to shift. for auto-cross or roadracing, a manual is necessary because u control when to shift and what gear to stay at.
as far as mechanics go, an automatic tranny has more moving parts.