Thats exactly what the pvvx customised Xiaomi Mijea LYWSD03MMC with the reed switch does.
Check the 2026.5 ESPHome update release notes that contains updates for ESP32 C6 & H2 SOCS, as well as nRF ZigBee and deep sleep modes, all of which may tempt you in different directions.