I found this site a while back - basically it will ask you a bunch of questions on your usage of your PC, and will came out with a list of recommended distros, and a list of reasons why YOU could like or not like it.
There are some similar sites to this one, but since I’m not familiar with them, I won’t post them. They are simply DuckDuckGo-able though.
I always had great luck with Linux mint and LXDE personally.
Did you use the link in this post yet?
@stevedidWHAT @iortega Your best bet is to use a distro that allows you to choose everything you install (at least your desktop experiences) so that you can install the lightest DE/WM you can. I would suggest something like CachyOS or Reborn, that have choosers and then choose something like openbox. Archcraft is also quite nice and light. I run it on an old machine and it runs beautifully.