What is "SDN", how is it different from the thing that everyone else has called "VPN" for a few decades, and why not just have its resolver serve answers for the same TLD? Or better yet why not just route your home subnet over the VPN subnet (probably with a high metric, so that it doesn't override "real" routes) so you don't need a different IP?
Match is extremely useful though. It's in use on a few systems I control to allow password authentication from certain subnets.
Worth noting that I actually just use split-horizon DNS for my personal VPN though. Telling Unbound this is a lot easier (and still works with stuff that isn't SSH):
local-zone: "mydomain.com." transparent
local-data: "foo.mydomain.com. A 10.0.0.4"
Match is extremely useful though. It's in use on a few systems I control to allow password authentication from certain subnets.