Is 32GB of RAM worth it for CS:GO, League, and Valorant?

No. Stick with 16GB. Those games were designed to run on hardware from ten years ago, and 16GB is already overkill—you could probably get away with 8GB. Save your money for a better CPU or a 144Hz monitor instead.