Discussion about syncing WordPress site content: Sync user (modified) content
Tool that transfers WordPress site content + uploaded files, adjusting URLs in the process: Leveraging WP-CLI Aliases in Your WordPress Development Workflow - It overwrites, it doesn’t sync though.