I have a site to site VPN between my house and my parents house. I have a camera at my parents house that I monitor on my home BI setup. It works just fine if your internet speeds are capable of supporting all the data you expect to be sending from the second home to your primary house. You'll especially need to pay attention to the "upload" speeds at your second home. While getting service with the same upload/download speeds is becoming more common in the US, there are still plenty of service providers that have healthy download speeds, but terrible upload speeds.
I will strongly suggest that if you care about or "need" this footage at all, that you set up a BI system at the second home. This will not prevent you from viewing the camera at your primary residence, but I would never rely on the VPN/internet connection to be the primary source of footage. Even if you still want to record the footage at your primary house to be able to make it easier to look back at alerts etc, I would still want to have my primary recordings be done "onsite" at the second home to ensure they were always recorded even if the internet went down.