I just looked up a sample of the SQLite codebase[0] and it seems to align with what most people are saying here, to keep a minimal amount of comments and the ones that are there should comment what the code can't tell you.

[0] https://sqlite.org/src/fdiff?v1=7c288b4ce309b5a8&v2=8efa2c81...