Meaning, you have some kind of deterioration in the system, when it all worked fine before. So it's not about the BIOS version.
There's two main routes of troubleshooting now: Ruling out things by leaving them out, and ruling out things by using a different one of them. What you can first try, take out the GPU, take out / disconnect the SSD, leave only one RAM module in slot A2. Do you still get the DRAM LED? Then those parts you took out are ruled out, they have nothing to do with it. Since you also tried four different RAM modules (you could try them all in a different PC to be sure), it should now be between the PSU, board, or CPU. So then you'd try with a different PSU next (because it's usually easier and less hassle to try with a different CPU first). The other PSU has to be known good, not too old, and of
decent quality.
If it's the same with a different PSU, then it's only between the CPU (which houses the memory controller, BTW) and the board. So now you'd have to test a different AM4 CPU in that board, or your CPU in a different AM4 board, to see which one of them it is. I will say this, there have also been rare cases where people on AM4 have just swapped their CPU cooler and suddenly got the CPU LED afterwards, which would suggest some kind of contact problem between CPU and socket perhaps, something like that. But you got the DRAM LED and you haven't said anything about a physical change to the system, so it might have some actual defect that has developed.