[Metricbeat] AWS CloudWatch metricsets are not connected to Elastic Agent health reporting

The AWS cloudwatch metricset and any other metricsets that depend on it simply log errors and do not report the error in a way that is connected to the Elastic Agent status reporting framework. This means that an authorization error does not mark the integration running the relevant AWS input as failed, it continues to appear health when run in Elastic Agent or as a Managed Integration.

https://github.com/elastic/beats/blob/71bccf4c9cefefde247e775b12c19b042bd47fdb/x-pack/metricbeat/module/aws/cloudwatch/cloudwatch.go#L208-L225

It appears that the billing and awshealth metricsets have the same problem.