Temidayo Omoniyi likes a good pattern:
This article is divided into three major sections—each showing the different abilities and use cases of performing incremental load with Azure Data Factory. This process can also be done in an Azure Synapse Pipeline and Fabric Pipeline.
The document contains the following:
Section 1: Copy Data Based on Last Modified Date or Latest File
Section 2: Incremental Copy Using Dataflow
Section 3: Incremental Copy Using Lookup and Stored Procedure Activities
Click through for each of these three patterns, with plenty of screenshots and step-by-step instructions.