I don't know exactly where you saw this, but Site-to-site VPN Translation is super simple to understand.
Basically it will translate the IP address of a given host in a Subnet to another IP.
Example:
Supposing you have the 192.168.128.0/24 subnet and need to translate it to the 10.15.30.0/24 subnet, when your host with the IP 192.168.128.44 communicates with your server within the VPN, the host's IP will be translated to the IP 10.15.30.44.
Basically that's it, there is no other advanced feature.
I am not a Cisco Meraki employee. My suggestions are based on documentation of Meraki best practices and day-to-day experience.
Please, if this post was useful, leave your kudos and mark it as solved.