Consider me in - mine also becomes increasingly unreliable so I'm finally pulling the trigger.
I have a strong suspicion that your 3x WD Black died are not related to them but the SBC having unstable internal power circuit.
Because I do also have 2x Enterprise SSDs failed and 2x White Labels making troubles after being connected to both the USB3 and the SATA-HAT.
Right now I'm using it with the NVMe Hat with OMV but whenever I restart I get an smart error counter increase - on each single restart.
After the USB related issues making the drives mounted RO I'm finally giving up on this and Arm-SBCs as a whole (bookworm/5.16-rockchip) and going back to x86 completely. I have had a shitload of them and all the fun issues regards to big.LITTLE (e.g. KVM) and lack of distro support because of the bootloader mess / missing Adoption is just making this a big no-fun adventure anymore ...for me personally.