Yeah, this discrepancy really irks me in programming, too. It's really good at known problems, like student homework or whatever task a middle manager will throw at it to see how well it works.
But because of the nature of software – if there is a solution, you can easily share it with everyone in the world – it's kind of our job to work on anything but known problems.

Yeah, there's gonna be some known parts, where it may be able to assist, similar to a library or StackOverflow. But if it can put together your whole solution without tons of human input, chances are that solution is already out there and you should be using it instead.