if on a remote server (e.g. using `auth_local_webserver=False`), then don't cache user credentials by default

If on a remote server (e.g. using `auth_local_webserver=False`), then there's a good chance the code is running on a shared machine (e.g. a VM or Colab notebook). In these cases, we should not cache credentials to a local filesystem, as there is a chance that other users have access to the same machine.

If I remember correctly, Colab already has patched this library to disable the caching when installed there, but it'd be great if we could do this by default in a way that works for all potentially-shared environments.