I use this to encrypt files as well and I think Emacs handles this very well for individual files. It is however the notes management tool that doesn't support transparently search through multiple files.

I imagine what is needed is using gpg-agent to handle passwordless decryption of the files at rest.