If you have a V3 Cam, you can add the spotlight accessory that will come on with motion or AI detection. The V3Pro and the OG S have a resident spotlight for this.
There is a Wishlist request that asks for the cam custom sound capability. Follow the link to that thread, vote for it at the top, like some posts, and add your use case in a reply post at the bottom.