Should I get 16GB of RAM for my budget build?

No, it’s not wasted money — but you don’t strictly need it for Valorant or CS:GO. Those games run fine on 8GB.