I only store “rare old hard to get stuff that I loved a lot” but I just delete everything else after watching so I never have more than a 1TB drive half empty from which I also delete what I downloaded but will never watch after some time. All of that on my Raspberry pi home server with Emby and CasaOs.
I use songtube It is open source, you can download the videos or just the music, listen with the screen off, it is also a music player and it is more eye candy than newpipe.
Windows isn’t Linux’s brother !