Overdraft protection can be a good idea if used correctly. Here are some pros and cons to using this service.