Location definitely matters, but it depends what the VPS is actually doing. I use BeeksFx LD4 offered by HFM free of charge if you meet turnover requirements. For a normal website, being near the audience or using a CDN helps; for an EA/trading setup, I’d care much more about latency to the broker’s trading server than where the users are.