I got my first automatic a few years ago, not necessarily out of choice, it was a cheap well maintained car of a type I liked that happened to be an autonomic and quite like it.
I like the simplicity, we close to the city centre with a lot of stop/start driving, so it is ideal but there are downsides. I've driven a manual transit and my dad's manual and for suburban/motorway driving and in free flowing traffic I didn't find it that much of a pain at all. So depends what sort of driving you'll be doing.
Automatics only tend to come in the bigger engine and higher trim specification of a given model, so are more expensive to buy and possibly insure. They are also less fuel efficient (about 10% less so generally)
You can't use engine braking and you have to be a bit heavier on the brakes then you would be in a manual. You can't push or bump start them (an issue, if like me you don't drive it that often or fall asleep in a service station with the lights on at 2am )
I can see if someone who is a bit of a control freak wouldn't like an automatic, the only time I've felt I'd like a bit more control is in ice or snow, as you can't use the gears, but not insurmountable if you don't drive like a douche.
Would you husband consider a manumatic gearbox? (the ones with the flappy paddles like on F1 cars) that would be a good compromise, but would limit you in availability terms.