Auto for me now, and for many years.
Although you'd need a bigger difference on cc to get the same 'kick', but if you are looking at 1.6/1.7 probably 'kick' is not what you are after…
I don't know why anyone wants to drive a manual myself, just don't see why you'd want to put yourself through the constant stop/start.
Yes, they are worse on fuel (about 2mpg on mine), not enough to make me want to drive a manual and a bit slower (on my car 0-60 in 6.3sec for manual and 7.4sec for auto)
IMO auto also are faster, due mainly to when you lift off the gas, the car just carries on 😆
And if anyone says they are 'boring' or how they like to 'drive' a car, just come for a drive with me on a fast/bendy A road.