Getting fed up of replacing these coin cells and it might be helpful to have a list of devices that use the larger cells like CR-123a. I know this isn't directly addressing the issue, that being "finding devices that sip vs slurp power"...but it might be a reasonable surrogate as it seems these larger batteries last longer no matter what HA device they're in.
Maybe the battery spec would be better as a column entry in the HE Device Compatibility List ? (https://docs.hubitat.com/index.php?title=List_of_Compatible_Devices)
Function / Device / Protocol / Battery
Motion / Visonic MP-840 / Zigbee / CR-123a