(1) Background: The neddylation pathway assumes a pivotal role in the initiation and progression of cancer. MLN4924, a potent small-molecule inhibitor of the NEDD8-activating enzyme (NAE), effectively intervenes in the early stages of the neddylation pathway. By instigating diverse cellular responses, such as senescence and apoptosis in cancer cells, MLN4924 also exerts regulatory effects on non-malignant cells within the tumor microenvironment (TME) and tumor virus-infected cells, thereby impeding the onset of tumors. Consequently, MLN4924 has been widely acknowledged as a potent anti-cancer drug. (2) Recent findings: Nevertheless, recent findings have illuminated additional facets of the neddylation pathway, revealing its active involvement in various biological processes detrimental to the survival of cancer cells. This newfound understanding underscores the dual role of MLN4924 in tumor therapy, characterized by both anti-cancer and pro-cancer effects. This dichotomy is herein referred to as the “double-edged effects” of MLN4924. This paper delves into the intricate relationship between the neddylation pathway and cancer, offering a mechanistic exploration and analysis of the causes underlying the double-edged effects of MLN4924—specifically, the accumulation of pro-cancer neddylation substrates. (3) Perspectives: Here, the objective is to furnish theoretical support and novel insights that can guide the development of next-generation anti-cancer drugs targeting the neddylation pathway.