I've tried using it for document production, but found it too restrictive. I've not tried it for literate programming, as I still find RStudio and MATLAB better for IDE's for R and MATLAB respectively.
Now, I still use org-mode for project notes, at work or as hobby, usually (but not forcibly) one file that starts out very freely and gets more levels/organization over time.
The key for me is that I don't have to adhere to some organization, I can also just jot things down without structure or reason. But I may often reach a point where organization sets in beneficially.
Initially I used markdown, but I recently switched to org-mode. Initially I'd just copy/paste commands and output, and create daily todo-lists for myself.
Now I find I'm learning more and the use is spreading into other areas.
I put together a simple example of my worklog here, in case it is at all inspiring: