We first got up and running with OpsWorks about 6~7 years ago, at a time when many of its competitors were far more limited. At the time it made sense as the logical tool to go with and getting up and running on the AWS infrastructure was beneficial for the scale we were looking to manage. Since that time many other tools have come a long way. We use Heroku for smaller projects and it's far easier to get started with and manage, but pricier at scale. We also use GAE to run some smaller projects and it's a contender should we ever need to scale further and migrate to more manageable infrastructure at scale.
DigitalOcean is my favorite for smaller projects and provides by far the best price point, but it may be less desirable for companies looking for a larger scale. All said, with some of the great DevOps tools like Kubernetes/Docker/Terraform I don't think I would go with OpsWorks again if I had to start over again at this point in time.