There are two classes of programmers: the taught and the self-propelled. You can certainly teach someone to program--what they do after that defines the rest of their career. No CS curriculum will give all the information one needs to be a great programmer, but it's certainly possible to have a long and mediocre career as a taught programmer.

I would wager a majority of the best programmers are also self-taught, though. Not because College is a bad experience or sets you up for failure, but because it's really internal motivation and curiosity that makes a programmer grow, not something they learned in a CS course once upon a time. And you've got to be pretty damn curious to make a career of programming without any formal introduction or education.