Everyone I know who has done so is completely convinced it's a better experience. Personally I like being in control of the gears but all that have gone auto have never looked back. Is it the same for you? My idea is to compromise and go for an auto with paddle tabs to change manually if I want to go manual.
Note – Didn't want to put this globally as I know many countries have auto as the norm but UK is a bit more reluctant to go automatic.