MyCloud stopped working (permanent yellow light)

Given the things you have tried, my gut feeling is the same. I think you may be looking at salvaging your data:

If this is successful, and the HDD is still working, you might try reinstalling the firmware, using one of the ‘unbricking’ guides.

If there is no activity on the network port LEDs, it is possible that the network port hardware has died; there have been quite a few reports of that problem.