Since the vast majority of players try to capture cities in 1 turn, auto-bombard is pretty useless, espcially considering that units heal between rounds.
The only time I have ever used it is when I have a couple ships trying to bombard a coastal resource or lux. Frigates in particular have a very low bombard value and it's quite annoying to have to command it over and over.