Sense Hub doesn't report a leak sensor that has gone offline

Not at all. Seems logical to me to want to know that your house gets flooded.

I have held off on the hub since it has been reported that hubs don’t recover after a power failure.

Seems I have another reason to hold off on a new hub purchase.