Does VPN really hide your location? How?

Those are failures that one has to worry about if one uses a commercial VPN. Any ideas of failure modes if one uses a private vpn such as algo vpn on one of:

  1. azure;
  2. digital ocean;
  3. ec2;
  4. gce;
  5. lightsail;
  6. scaleway;
  7. hetzner;
  8. openstack;
  9. cloudstack;
  10. vultr; or
  11. linode.

I have been known to change cloud providers, just to mix things up.