The Pyrazole Scaffold in Anticancer Drug Discovery: A Review of Synthetic Approaches, Structure–Activity Relationships, and Target-Based Mechanism of Action | Synapse