Numerous acupuncture studies have been conducted on cancer-related pain; however, its efficacy compared to sham acupuncture remains controversial. We confirmed whether the outcome of acupuncture differs according to the needling points of sham acupuncture for cancer-related pain. We searched 10 databases on 23 May 2023 to screen acupuncture trials using sham acupuncture or waiting list as controls for cancer-related pain. Sham acupuncture was classified into two types, depending on whether the needling was applied at the same locations as verum acupuncture (SATV) or not (SATS). A network meta-analysis (NMA) was performed on the basis of a frequentist approach to assess pain severity. Eight studies (n = 574 participants) were included in the review, seven of which (n = 527 participants) were included in the NMA. The pain severity was not significantly different between SATV and verum acupuncture, but verum acupuncture significantly improved pain severity compared to SATS. The risk of bias affecting the comparisons between the verum and sham acupuncture was generally low. Previous acupuncture trials for cancer-related pain showed differing outcomes of sham and verum acupuncture, depending on the needling points of sham acupuncture. The application of SATV cannot be considered a true placebo, which leads to an underestimation of the efficacy of verum acupuncture.