Now, there's a tiny percentage of the population that enjoys paddle shifters, and even I do sometimes, but if we had usage tracking on them I would bet that fewer than 10% of drivers use paddle shifters for more than 5 times in the lifetime of the car, and that cars with paddle shifters are in automatic transmission mode 99.9% of miles driven.
So though some people will miss the gearbox, far far far more will rejoice in having a car that is always at maximum performance without messing with things.
'S' behaves more like a human driving a manual - I assume the MPG and emissions testing is done in 'D'
Edit: so, I went to try sport mode and... turns out I've been driving around in sport mode all weekend already. Tried out "comfort" mode just to compare and couldn't see any difference. I'm sure a better driver could, but both are far away from instant response.
I drive a car with the VW EA888 2.0 (230BHP@4000RPM, 370lb-ft@1600RPM) and it is possible to have near immediate throttle response and pull provided you're familiar with the gear ratios and power curve of the car. However, it's also a manual, so I don't have the disadvantage of being caught out in the wrong gear.