I made a deposit to Hashbot for $90
It was worth $55 at the time you made the transaction, and is currently worth $80.
How long will it be before the transaction is forgotten, and therefore the balance reappear in my wallet?
If it's unconfirmed for this long, that means it's still being broadcasted.
Or, is it possible to do a child pays for parent or similar transaction to change the output from the scam wallet address back to one of my own?
CPFP is something 'Hashbot' could do, by sending the unconfirmed funds with a higher fee. This means the current transaction gets confirmed, which is not what you want.
FYI the transaction was made through blockchain.info wallet, but happy to export my private keys into a new wallet if it would provide additional options.
Most of your inputs are too small to be worth the fee at the moment. I suggest you export the private key for 1ETSFvQ5VQJ1jQRCgf9c2vXd9uwX5tn5GE only. Easiest is to import it into Electrum, see if it picks up the existing unconfirmed transaction from mempool, or that it lets you make a new transaction.
Once this new transaction gets confirmed, your previous unconfirmed transaction is dropped.
I used to think I was reasonably well informed, but after reading various websites i'm very confused about what to do next so help would be much appreciated!
Keep the rest of your small inputs, and consolidate them if fees ever get lower again.