JIRA is a great example. I used to have automation when it was hosted on prem and I had database access.

Now it's locked into the cloud with piss poor APIs so they can sell you more add-ons. I'm actively looking at alternatives.