Is DM automation useful for an agency managing client accounts?

Yes, with two caveats. Cost should not scale with the client's audience, or a client's growth quietly reduces your margin, which is the main argument for flat pricing. And you need exportable contacts, because the list you built is part of what you hand over as proof of work at the end of an engagement.