It seems for creative work there must be a mix of free-flowing generative processes, where you come up with ideas (in a euphoric? manic? state), followed by pragmatic (depressive?) critique of the generated ideas. This back and forth of idea creation and critique is what results in a refined final result. It also might explain why, anecdotally, bipolar individuals tend toward creative careers. Similarly helps explain "write drunk, edit sober."

I also contend that few programmers/programming positions require this sort of creative process. Perhaps "hacker" is the better term for a technical+creative identity.

If your depression includes copious amounts of self-doubt, nope. :)