> What do you hand a docker-compose file off to in production

Why hand it off to anything?

> When would you choose this path over a separate system to provision your production resources

When you have a simple system with modest availability requirements and you don't like unnecessary complexity.