I access my servers at home from work through the appliance. Don't see
why it wouldn't work the other way around. In my case, the home has static
IP, so my issues were all the same as yours.
However, from carefully parsing what you wrote, it sounds like what you
really want is a routed VPN tunnel, not a bridged one, which is what the
appliance is currently giving you.
Bob