Dome siren might be really what you want. Echo Speaks will do the trick too.
I use Zigbee door sensors to trigger Google Assistant Relay (no Google Home device required), and that triggers a virtual motion sensor in the SmartThings cloud (no SmartThings hub required). Alexa detects the virtual motion sensor becoming active and announces the door that just opened. You will need to build Google Assistant relay, but that's a super valuable thing to have available, so worth the effort. You can use that for controlling devices that are not compatible with Hubitat or Alexa, but are compatible with Google Assistant.