How enforceable is an NDA really?

In stories, especially creepypasta, its sounds more like a magical contract than a piece of paper

Like if a private organisation hired you to kill people, a NDA doesn't somehow make that legal and you can't get sued for breaking the contract.

So, what is the legal extent of NDA?