Microsoft just keeps knocking it out of the park lately. The most recent announcement to catch my eye is that in SQL Server 2019, they are introducing Read-Write Secondaries for Availability Groups. Meaning the end user doesn’t have to know the listener name, they can be pointing to a secondary server directly by name and, as long as it is setup correctly, it will always send a read-write connection to the primary replica. This is a huge advantage because you no longer have to segregate your code into read and write calls and include ApplicationIntent=Readonly in order to scale your reads. You can just round-robin connections between all replicas and the writes will always redirect to the primary.
Read more from Microsoft: