What is the watt of your power supply? It could be that you have weak power supply and you connected so many things maybe.
I'm running a TUF x570 and haven't heard of or experienced this. Thought I'm only running a 1tb nvme m.2 right now...I do have a 4tb HDD to install soon and I hope it doesn't cook...if it does, Ill report back.
For your situation Id consider an external drive in addition to the computer drives. Only plug in in for back ups then unplug it, much less can happen when it isn't powered on and being commanded by something.
As far as the drive data...I know some drive manufacturers offer data recovery services for their drives. Maybe try hitting them up and see if they can help you out.
As an update, Asus is RMA'ing the board for me, which is little comfort. I had to replace the destroyed drives myself, which cost more than the board. And I have not recovered the data on those drives. It is possible to do a pcb swap on the broken drives, but it requires unsoldering and replacing the ROM chip which I'm not qualified for.