For my use case, it's not bad, but the students are working through the lessons in class with me there to help them when they get stuck. And they get stuck a LOT. The lessons are improving (slowly!), but they've still got a LONG way to go.
I can't imagine anyone is teaching themselves to code anything using CodeCademy that couldn't have done just as well using a tutorial online. Anyone with the natural aptitude to make it through their lessons could teach themselves with damn near anything.
At Hackbright however, I found learning with CodeCademy to refresh some knowledge is helpful, especially with a teacher around to ask questions. Most of the time, the questions confirm that my solution is also valid, but it's just different from the CodeCademy answer.
I wanted to get some fundamentals on Javascript to be more capable with D3.js.
If I didn't have all of that previous knowledge, I would find it really difficult to get going.
I wouldn't call Codecademy overrated. But I'd say that geeks like me (and probably you guys) are the wrong people to be evaluating Codecademy.
If they're not testing out their teaching methods on n00bs, they should get on that right now.