[Managed] Create a best practice managed experience with the operator

[atoulme]

Managed CR

This feature request tracks the creation of a new custom resource which automates the provisioning of collectors, target allocators, auto-instrumentation webhook managers and so on.

This custom resource will set up all the resources to create a cohesive, out of the box experience of OpenTelemetry, with the same feature set as https://github.com/open-telemetry/opentelemetry-helm-charts/tree/main/charts/opentelemetry-collector.

This is a bit of a change compared to the existing CR in the sense that this is an opinionated CR which will define behaviors. The user configuration exposed on this CR will be minimal, typically just setting the data destination.

[iblancasa]

I think it would make sense to create one RFC https://github.com/open-telemetry/opentelemetry-operator/blob/main/docs/rfcs/template.md

[jaronoff97]

@atoulme do you think should supersede, close, and/or reference some of the prior work (cc @frzifus) #3297 #3279 #1906

[atoulme]

This prior work seems intent on fixing specific issues, I see this CR as a user experience where the operator in its totality is simply managed, and therefore doesn't talk about sampling, or exposes the collector configuration.