I feel very sorry for this guy. This doesn't seem like something planned by a crackpot or someone suicidal/homicidal. I'm guessing undiagnosed mental or brain illness, or accidental dose or overdose of something. Flight crew members have snapped in the past, often with disastrous results, but the only ones I can recall involved a plan brewed during a slow descent into madness, triggered by career or personal problems.
Whatever the case, it's just a damn good thing nobody got hurt.\He's done with flying, I guess, but I hope he gets better.
As for cockpit cameras: they'd really only be of any use after the fact, just like CVRs. I sympathize with airline pilots who oppose them- this is not like surveillance in the corporate or retail world; where it's mostly about stealing, and very useful for such investigations. It's useless, really... they already have devices recording what they say, and all their control and FD inputs.
On the other hand, I toil under Big Brother's watchful eyes on a regular basis, and I know that nobody's going to see me scratch my butt unless something goes missing or gets broken and they think I may have been involved. They don't bother me at all, even though I hate having someone actually looking over my shoulder. Let me put it this way- I've never seen a camera watching LP or security personnel in the room where they're supposed to be watching the customers, contractors, and employees.
If they're alone in that room (or just with some anonymous tech like myself) they are usually doing something else, like sleeping or web-surfing.
A camera would have done nothing to prevent this incident, or deal with it. Better to use that kind of money for external cameras, so the crew can see more of the aircraft!