Modifying scraping metrics using ADOT

### What would you like to be added?

ADOT PM here.

In [Scraping metrics using AWS Distro for OpenTelemetry](https://www.eksworkshop.com/docs/observability/open-source-metrics/adot/) currently the OpenTelemetry operator is manually installed and used. It would be great to replace this setup with the [ADOT EKS add-on](https://aws-otel.github.io/docs/getting-started/adot-eks-add-on) which under the hood also uses the OpenTelemetry operator, however provides a more convenient UX for customers. In the case of AMP, see [Collector Configuration for Amazon Managed Prometheus](https://aws-otel.github.io/docs/getting-started/adot-eks-add-on/config-amp). Note that the content also exists (in simplified form) in the [EKS docs](https://docs.aws.amazon.com/eks/latest/userguide/opentelemetry.html).

### Why is this needed?

Improve UX