While optimism is often celebrated, a new study reveals that excessive optimism can lead to poor decision-making, particularly in financial matters.