If it is an everyday car my choice would be an automatic. The car is merely a tool to get me from place to place and I prefer having as little fuss as possible. Even if it is an econobox I'd prefer to have it as an automatic as chances are it is a dreadful car and whether it has a manual or an automatic it is unlikely to make it any less dreadful. In terms of fuel efficiency, it isn't at high enough a priority list that I could be bothered to opt for a manual, in any case the gearbox of a car is rarely ever the only factor in a car's fuel consumption, driver behaviour plays far more of an aspect.
If it is a car that is meant to be used as a fun car then it may or may not be an automatic. Currently all the cars I'd consider buying for recreational driving are a Jaguar F-Type, Nissan GT-R and possibly if I win the lottery a Lamborghini Aventador or Huracan. None of it are sold as a manual.