I think the biggest issue here is the fact that keystone doesn’t have a service account or something like that.
Application credentials are tied to a user unfortunately, trusts are the same. There's no way for a user to create a user for the cluster.
I guess in the CAPI world if we have admin access we can create a user for the cluster in the project but that probably has its own set of problems.