Yeah, the ability to send to multiple sources is quite powerful and most of this comes from the configurability of Otel Collector [1].
If you are looking for a open source backend for OpenTelemetry, then you can explore SigNoz[2] (I am one of the founders) We have a quite a decent product for APM/tracing leveraging opentelemerty native data format and semantic convention.
[1]https://opentelemetry.io/docs/collector/ [2]https://github.com/SigNoz/signoz