The orgmode hype I still don't get. I code full time in emacs and still don't get it. Maybe because all the use case blog posts I've found can be reduced to "you must discover a user flow for yourself."
I can't even tell whether I should have more than one .org file.
Do you take a lot of notes? If so, what do you use to take notes? Some people don't take a lot of notes, and Org mode might not be useful to them.
My personal wiki includes several thousand .org files that are interlinked using hierarchical tagging. No other note-taking tool I've evaluated has all of the features and efficiency of Emacs and Org mode.
For example, Evernote doesn't allow users to enter tabular data and make calculations on that data, which Org mode supports. The suggested solution for Evernote is to attach a spreadsheet file. That's what I did with the various note-taking solutions I used back in the 90s. Now all of my small sets of tabular data are included in the same files as my notes.
Orgmode sort of standardizes a bunch of things that are useful for project management and note taking. Things like putting due dates and then building an agenda for the week based on that.
How you use it is largely up to you. I usually break things into files when I feel like it's its own high level "thing".
I tried Notion but there's something I don't like about it. It's also kind of slow. I have been using Bear and I like its simplicity and features a lot!
From what I can tell it's somehow possible to link to file locations in a .org file, and sometimes I'm able to cause emacs to open that file within the ide, but I'm shaky on the details.
Nothing beats emacs/org-mode + beorg on iOS for me though. beorg even has scheme-based scripting, although I haven't tried it out yet.