Cash app transfer failed refund can take 1-3 days as per your bank terms & conditions. Basically, the amount will be refunded into your Cash app balance instantly if the transaction made via Cash app balance or debit card. But, if transactions made via a credit card, then refund go into a credit card as well.
https://www.email-contactsupport.com/blog/cash-app-transfer-failed
How long it takes for a refund of Cash app transfer failed?