Some of this mistake were in the early days probably, I didn't experience address mistake but they are rare today. Most modern wallet have error checks, if you paste an address and the wallet is not correct, like there is a missing character, it will detect it because it's having a checksum which helps you to validate the address. Unless you replace a whole address by mistake which I don't think it's a mistake, that's negligence from the sender.

If you enable RBF on your transaction, you should have double spend it with a different input amount and rest to your address as change.

I once made the same mistake when I wanted to buy Bitcoin testnet4 coin from a Chinese supplier. There is a market I could have bought the testnet coin market place but I was trying to avoid excess fee, I will be charged a deposit fee if I want to use the platform. I contacted a seller directly, we agreed on the amount but over send for him. What saved me was the transaction was having RBF enable, so I double spend the transaction and send the agreed amount to the person and return the rest as change to my address.