You do need to create a complete automation process.
Automating the cert renewals is only part of that.
Updating PowerPages is another part - but I'm confident that there must be ways to automate that as well.
I'm not familiar with:
Maybe you can check through their website OR speak/email with one of them to see if they support DNS automation.