Add more logging of exceptions in backends

[Skylion007]

A lot of backends can throw exceptions that are swallowed by fsspec, we should at least log these errors in debug or info level using the builtin loggers with exc_info=True to improve the debugging experience of the library.