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?
Depends. On who you are, what their situation is. The law is not automatic. It is won by lawyers not “the law” itself.