That would be so cool! As an academic, one use case for me is for my notes to eventually become usable question banks (for the classes I teach, and all the student recruitment we do at all levels) and useful indices into papers (what is known about X/Y/Z). I'd also love to be able to pull up notes from meetings with someone, or in the context of a particular project - I think this is already covered by some office hours though.
I can be disciplined about doing the frontmatter etc. properly (great to have schemas and templates for this, if I understand correctly), so the missing piece right now would be the dataviews.
That said, a) it'll be a while before my database gets to the point where I can flex this way, and b) code-search will work well until then. Will look forward to the datasette integration, that appears to be another cool tool that I was completely unaware of.