Emit more breadcrumbs in `@sentry/node`

[mydea]

Description

We should check all our existing Node instrumentation to see if we can easily emit breadcrumbs as well.

It is important not to tie this to spans, as these have no data when not sampled. Instead, where possible we need to use hooks in instrumentation to create breadcrumbs.

### Tasks
- [ ] genericPool
- [ ] kafka
- [ ] mongo
- [ ] mongoose
- [ ] mysql
- [ ] mysql2
- [ ] postgres
- [ ] prisma
- [ ] redis
- [ ] fs

[timfish]

Unfortunately, The only one of these otel instrumentations that has a hook that gives us the ability to add breadcrumbs with sampling disabled is fs which has a createHook!

[timfish]

It's also worth noting that even where we have the createHook for fs, I don't think the endHook gets called with tracing disabled so we can't breadcrumbs with the correct status depending on the result. We also have requireParentSpan: true so even with tracing enabled, you would not get breadcrumbs unless there's a parent span!

We also have this problem with the undici integration where breadcrumbs are created in the responseHook so they are not created with tracing disabled.