Some minor changes are required to handle multiple tables. I will try to write an article on this.

Thank you for your feedback.

You may please refer the article https://www.sqlservercentral.com/articles/incremental-data-loading-through-adf-using-change-tracking.

Let me know for any more question/query on this.

You may try all the steps again with the attached file. Please make sure that the required permissions are in place.

Thank you for your feedback.

My response on your questions/remarks:

1. This solution will work if the source data contains a WaterMark Column -- yes.
2. Step 11: Add Parameters: These parameter values...

Step #10 is same as the screenshot shared at step #4. Only the login id and the password used in the two steps are different.

The CSV file I have used...

Azure Synapse Workspace (currently in preview) has the Copy data activity integrated where ADF resource need not be created explicitly.