Where are all the "green jobs" we were supposed to see?

Lots of luck finding them, says NYT in a recent news article.  California received $186m in stimulus funds to insulate homes two years ago; so far, only half the money has been spent and 538 jobs have been created.  That comes out to almost $350k per job.  Spending has been slow because, even with the federal subsidy, consumers are unwilling to pay the cost. 

To be fair, there aren't all that many new jobs to talk about in any sector of the economy.  But politicians have clearly oversold the role that green jobs will play in the economy.  Money quote from NYT:

President Obama once pledged to create five million green jobs over 10 years. Gov. Jerry Brown promised 500,000 clean-technology jobs statewide by the end of the decade. But the results so far suggest such numbers are a pipe dream.