How many programmers does it take to change a light bulb?
The question's wrong. It's a hardware problem, not a software one. Get the hardware engineers to fix it. Of course, the hardware engineers will want to work around the problem in software. . . .
Is it better to be enthusiastic and less skilled (not incompetent) or to be incredibly talented and unmotivated?
Who will write the better code?
Who is the better programmer? (Not the same thing.)
Which does more to shape the code you write: your technical competence or your attitude?
There are various types of software systems, and the creation of each requires a different set of skills. That's how programmers can carve out niches in embedded programming, web services, ...