On the other hand, it's also the reason behind most of my missed deadlines ("Oh yeah I can do that in a week, no problem"), burnout ("I've got nights and weekends, I can take on this project"), and disappointing/unrealistic projections ("I don't want to slow myself down with research, I KNOW people are going to love this product").
In my previous role, I was paired up with a developer whose natural tendencies were to pessimistically look upon each new feature request like a minefield. Having someone to negate the negative aspects of my optimism was a godsend, and we had one of the most productive working relationships I've ever had. I would unfairly get a lot of the credit for my positive, can-do attitude, but I've never forgotten the benefits of having a healthy dose of skepticism on a team, nor the absolute havoc that an unchecked optimist (like myself) can cause.