The Multifaceted Role of Flavonoids in Cancer Therapy: Leveraging Autophagy with a Double-Edged Sword