In the world of high-stakes poker, it is commonly understood that the only way to make a million dollars playing poker is not to want to make a million dollars. If you care about the money, your lizard brain takes over and stops you from taking the risks you need to take. As soon as you see the chips on the table as dollar bills, you're finished. Practically the definition of greatness in poker is the ability to play the same for pennies as you would for millions - as far as the great players are concerned, it's not really money, it's just how you keep score.
I think the OP is making a similar argument about startup founders - if you're emotionally invested in the payoff, your ability to make the right decisions will be impaired. You'll choose smaller markets, less ambitious products, make safer design decisions. You think too much about making money and not enough about growing a business. I think it's no coincidence that the likes of Page and Brin and Zuckerberg never really intended to start businesses. I think it's no accident that Warren Buffett still drives an old Cadillac and lives in his old suburban house.