Check out AWS App Runner. It may do exactly what you’re looking for.
That doesn't sound like the automated scale-to-zero I get from Cloud Run.
Most of the stuff my company is running is made up of data pipelines and machine learning pipelines. So we have a lot of infrequent jobs that don't really care about latency.