Automatic (and single-speed electric)
We're sort of forced into it because DW has leg problems and can't manage a clutch but we would probably choose automatics anyway. My late DF was a GP back in the days when they did house calls, and switched to autos because he got tired of an endless diet of first-second-third-junction-first-second etc as he navigated the back streets of the town to get to his patients.
When I learned to drive I started on his auto, and after I had mastered that switched to manual to get a manual licence. From then on, I hopped between autos and manuals without a second thought until DW came along since when I've driven automatics almost exclusively.
I don't think we've ever had a gearbox problem (fingers crossed) and generally the automatic experience is better.
I used to say that there were three kinds of driving: motorways, where it didn't really make a difference; town, where automatic is better; and the open road, where manual is better, so your choice should be according to the type of driving you do. Now, though, even the open road is congested and modern automatics are probably better there too.
If you had a really hot sports car manual might be more fun, but for a family estate automatic is going to be better.
As others have said, North America and South-East Asia changed to automatics as the norm decades ago. It's only in Europe where the manual gearbox keeps going as other than a niche interest.
Conventional cars only have changeable gears to deal with the fact that the engine isn't very flexible. Electric motors are very flexible, so don't need changeable gears (even reverse is by running the motor backwards) so as we move to an electric future clutches will quietly disappear.
DD1 will be learning to drive in two years and we are debating whether to put her for a manual licence or just stick to automatic.