[NestJS] SDK Enhancements

[chargome]

Open issue list for enhancements of the NestJS SDK.

• [ ] https://github.com/getsentry/sentry-javascript/issues/13167
• [ ] https://github.com/getsentry/sentry-javascript/issues/13133
• [ ] Upstream automatic instrumentation to open telemetry repo
• [ ] https://github.com/getsentry/sentry-javascript/issues/13169
• [ ] https://github.com/getsentry/sentry-javascript/issues/12823
• [ ] https://github.com/getsentry/sentry-javascript/issues/13287
• [ ] https://github.com/getsentry/sentry-javascript/issues/13517
• [ ] https://github.com/getsentry/sentry-javascript/issues/13589
• [ ] https://github.com/getsentry/sentry-javascript/issues/13590
• [ ] https://github.com/getsentry/sentry-javascript/issues/13810
• [ ] Investigate whether we want to provide a custom Sentry wrapper for the nest logger: FE-661