Great tool in general, but deprecated and EOL soon.
Use Cases and Deployment Scope
We've been using Opsworks for nearly 8 years and it has successfully allowed us to build and host infrastructure for large Drupal websites.
Pros
- connect between serveral AWS services (EC2, RDS, ELB)
- easy configuration management deployment via Chef
Cons
- integrating with newer AWS services (ie. ALB)
- keeping up with Chef releases (ie. locked at 12 currently)
Return on Investment
- very quick way of creating new infrastructure
- low maintenance costs
- easy to create high availability setups thus reducing costs
