zlacker

>I want whoever is physically close enough to the fridge to leave the door open to be notified.

Same - although I have experienced an interesting extension of this: HomePods now have alarm detection (the intention being to detect a smoke/burglar alarm). It is also triggered when the fridge is left open, leading to everybody in the household getting a critical alert (which ignores silent mode).