Personal preference is all there is to it these days, I reckon. I think you still get a bit better economy in a well driven manual.
I much prefer a manual in bumper to bumper freeway peak hour crawl - I have six speeds that I can use without any pedals. The car will idle in any gear up to 40km/h. I annoy the hell out of the 'run and stop' people, as I just keep the car idling along, and catch up to them just as they pull away again. Driving an auto in these circumstances requires you to always be on the throttle.
I expect that a CVT with a modern turbo diesel would be an absolute rocket ship, it could keep the revs at 2k and just accelerate all the way.
I do wish you could make the choice for any model of car, it really peeves me that once you tick the 'luxury' accessories with the car, that the manufacturer unticks the manual option.
I don't like the way that an auto won't let you amble along in a higher gear on a flat road getting good economy. They keep you in a lower gear with higher revs, or don't lock up the torque converter, so there is more energy lost.