[JavaScript] Implement more auto instrumentation for Node.js

[mydea]

Description

We currently already ship some auto-performance instrumentation with @sentry/node. Now that things have stabilised a bit, we want to expand support and add further instrumentation. There are some low hanging fruits, in OTEL instrumentation that exists that we can leverage.

[AbhiPrasad]

Thanks to help from @Zen-cronic and our js sdk commiters, we've gotten to a pretty good state with this issue.

We've added default integrations for tedious, kafkajs, amqplib, lruMemoizer, and genericPool.

We've added opt-in integrations for dataloader (upstream OTEL fix needed) and knex (upstream OTEL fix needed).

We decided against including socket io instrumentation because of some concerns about long running spans in the sdk, and the fact that we don't have websockets well specced out in general in Sentry's tracing model.

The only things left are Express v5 and Firebase. Express v5 is being actively worked on, we're going to rely on diagnostics channels to do it, just need upstream work for it. Firebase PR is WIP, but I think it can be worked on past this issue.

There'a also the vercel AI work which is tracked here: #13679

Once we merge in Vercel AI and do the next release of the SDK, I'll be closing this issue. Express 5, firebase, the dataloader fix can be tracked outside of this issue.

[AbhiPrasad]

Opened getsentry/sentry-docs#11799 to document the remaining integrations added in https://github.com/getsentry/sentry-javascript/releases/tag/8.38.0, as well as clean up some old entries.