I have made many mistakes when it comes to choosing a version of Linux for my PC. I have older PCs that can be revitalized by installing Linux on them so they don't just sit there ...

Absolutely. There are hundreds of active Linux distros available, with more under development. The key is to try different ones and find the flavor of Linux you like.