John Deardurff lays out some changes in SQL Server 2025:
A client requested a presentation discussing key improvements to Always On Availability Group fast failover in SQL Server 2025. I decided that a summary would be appropriate for a blog post. So, here I discuss Enhanced Telemetry, Persistent Health, and Intelligent Fast Failover
John has a very positive take on fast failover. I haven’t tried any of this functionality, but some of this does sound promising.