Provide a detailed theoretical analysis of quantum entanglement. Discuss how Bell's Theorem challenges the concept of local realism. Explain the EPR paradox and why the term 'spooky action at a distance' is considered misleading in the context of modern theoretical physics.