Recent Progress in Photothermal, Photodynamic and Sonodynamic Cancer Therapy: Through the cGAS-STING Pathway to Efficacy-Enhancing Strategies