Should decline your bank’s overdraft protection?

Overdraft protection might sound like a good idea, but does it really pay off?