[NestJS] SDK Enhancements

[chargome]

Open issue list for enhancements of the NestJS SDK.

### Enhancements
- [ ] 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