has anyone used the automation API with localstack for quick development? does it necessitate putting a custom aws provider on every resource or can it set on the stack level?

The automation API is just a wrapper around pulumi cli, so it is very same like using pulumi cli.

I would keep it at the stack level and create separate stacks You could do this in the same file with automation