Porphyrin Overdrive in Cancer: Unraveling the Mechanisms and Therapeutic Potential