No, the problem is that if you want to upgrade your CPU and GPU it's either used parts or a much higher budget. GPU + RAM is barely doable with 200$, so 250$ for RAM + GPU would be fine but for the CPU you'd either have to pay 250-300$ for an obsolete CPU that's not any faster than a new 100$ CPU or buy a new mobo and new CPU which with RAM and GPU would still bring you close to 400$.
So my suggestion is better RAM first, which might fix your problem in Valorant.
Check GPU usage in Valorant (now or after getting the RAM) to figure out if it's the GPU holding you back or something else. If it is buy a new GPU.
If neither was the problem or you still want more fps in TF2 start looking for a used CPU compatible with your mobo.
Alright I'll look into buying another stick of RAM then in that case. The current RAM stick I have in my pc is: Crucial Ballistix Sport LT 8 GB (1 x 8 GB) DDR4-2400 CL16 Memory. I know you mentioned trying to get the same model, but the only ones I could find have inflated prices or would have to be purchased used. Do you have a recommendation for RAM with the same specs that you think I should get? Or should I just try to get the cheapest possible?