Is having more gears better on an automatic transmission?

These days, many automatic transmissions come with eight, nine, or even 10 gears. Why is this, and is it actually a good ...