You never get anything for nothing. Regular coffee drinking adds nothing to your productivity. I can tell you this from years and years of drinking it. Any increase in productivity will be compensated for by an exact opposite later.
Even worse, regular drinking makes you dependent on it, and, although I've been spared this one, stopping can lead to headaches.
I have noticed that some of the most successful programmers I know don't drink coffee at all. I think they also likely lead moderate lifestyles with the right amount of sleep.
Now, that said, the occasional use of coffee can be a great thing, in my opinion, for short term boosts. These moments might be for things like jet lag... that sort of thing. Also, it can be great for safe driving if you are tired. Used in this way, caffeine can be beneficial.