Wow. I am sooo way late to this party. This is a great conversation, with a fantastic range of perspectives. A couple of things I thought about while reading all of these.
First. It's interesting that this role is still largely thought of in the singular. There wasn't real mention about the varying levels of Creative Technologists or the fact that you can have more than one of them at your agency.
As far as coding knowledge goes that has pro's and cons up and down the scale. Factoring items like level, responsibilities, team / agency structure and other realities of the working environment all effect the ratio. No matter what you have to know the basics such as variables, errors, functions, conditionals, loops, objects, arrays ect. Good languages all use these fundamentals and more importantly they set your foundation for how to solve problems. @robinow made mention of CT's sketching in code, which is cool but there are some of us that don't need to sketch in code because we can actually draw. It's one thing to "sketch out" an API mash-up of 2 random data sources. But it's another to draw out an idea's possible user flows, data relationships, experiential intersections, multi-screen strategy and how the brand/product flows through out it all before the client meeting is over. Again. It's all about the levels. Edward, knowing both Scott P. and Schatz you have seen the high levels of both sides of the creative and programming ratio.