Use debug log level by default

For background see https://lists.boost.org/Archives/boost/2024/10/258146.php.

> Oh cool. I played around with Redis the other day and failed to figure this out. Yes, not-logging by default really hurts adoption, at least in my case