App Runner is an abstraction on top of FarGate designed to compete with Cloud Run, which is why it doesn’t scale down to zero. I too haven’t found anything that beats the simplicity of a GCP deployment sigh..
In fact, I was waiting for years for them to add a min instances option. But otherwise, agree, been running large and small production workloads since it launched and its been great.