@toxi I find it's good at writing small, self contained bits of code that can easily be checked for correctness. think of it as a junior programmer (who remembers how to properly sort an array :) that you're delegating tasks to.
a lot of people who come at it with skepticism ask it to do things that it simply cannot do.
it's basically just a very good code snippet lookup engine, not a "fellow programmer".