Describe the reconciliation loop logic for a custom Kubernetes Operator that manages a distributed stateful application (like a custom database cluster). Focus on how you handle state transitions during rolling updates, leader election within the cluster pods, and disaster recovery if the whole node pool fails. Explain how you would implement the 'finalizer' pattern to ensure graceful resource cleanup.