I think it very much depends on the car. For instance, I'd only order a new non-GT 911 with PDK but I'd have a Cayman in manual. Something like a Bentley you'd only ever go auto even if it was an option. M4 I'd prob go manual (but it would be close), M240 def manual but the auto is amazing. 370 manual too, but it's not even close there. Something shopping trolley like a Golf R would be DSG for me, but I'd have a FRS in a manual. Odd, I know.
I wish the big boys would still offer a manual at least. 488 Pista with a manual 'box would be heaven, or even the 570S. The new R8 RWS would've been perfect for one too.