With Aurora DSQL, your application traffic automatically gets handled in-AZ, no configuration or hand-holding needed.
And no trade-off between consistency and latency either. DSQL reads are in-AZ and strongly consistent.
PSA: do yourself a favor and spend 1 minute to look at the locations of your app/database/Redis/Elasticsearch etc.
If they're not in the same region/AZ, you're missing out on a HUGE performance improvement