I really don't get having a ton of MD files lying around. And the possibility of having to edit a thousand MD files when the metadata frontmatter changes.

A single SQLite database implements columns/metadata handling, and comes baked-in with FTS and BM25 ranking too.