I'm worried that such API keys won't be usable anymore because even API keys for personal use with a single account require that application security review.

Furthermore, the Google Cloud console is not included in the typical Workspace subscription (for obvious reasons).