You might think being hard on yourself after a professional or personal faux pas will motivate you. But oftentimes, it has the opposite effect.