In the past, automatic transmissions made the car driving more comfortable, but they were not so reliabla and fuel efficient.
But the current automatic transmission technologies are much better because of their design and advanced software.
Current automatic transmissions are highly fuel efficient. They often have a lower fuel consumption than manual transmissions. It depends a bit on your driving style.
When having a car with automatic transmission, you can usually choose between the standard and performance mode. The performance mode offers the faster acceleration, but it consumes more fuel.