I’ve already switched to Lubuntu on my ancient laptop and for just streaming/watching media in vlc, browsing and sometimes torrenting, which is all that it can really do with the ancient hardware, a lightweight distro such as that is many times better than Windows was. It’s several times more stable and also quite a bit faster than it was!
As for taking the plunge on my main, though, that’s a whole different kettle of ballgames. Being able to run every game, including ones from “less official sources”, more or less effortlessly is my main priority on that one and afaik not even the gaming-centric distros have gotten THAT far, especially with Nvidia GPUs, which is what I have in the main…