Automatic debug logging and change default logger behaviour

### Description

`options.debug` being disabled by default leads and having a logger rely on it being set means we don't get any log messages (info, warnings, errors) if it's false. See https://develop.sentry.dev/sdk/expected-features/#debug-mode for more information how it could be handled to improve user experience (especially during for onboarding when they may have configuration issues).