I don’t have time now so I will sketch the solution

You need a proxy server in your vps that will redirect the traffic to your home. Caddy is usually recommended here and I am planning to migrate to it (current is nginx)

For your dns you need something is called zone name resolution, it will resolve different ip depending where the request came from

Good luck