I do take a lot of photos with my DSLR. I used to use Lightroom when it was a one time purchase software and kept everything in there. But the days of good photo-management software are over as it seems.
Now I'm using a folder structure that works for me
Year > Month > Date (or range of date) In each Date(or range) I have a "RAW" folder for the raw un-edited originals and an "iPhone" folder for my phone pictures in case I took some. I actually keep the original file name of my camera for all photos.
If it's a particular event I sometimes add a some kind of diary textfile in markdown in that particular folder. This can be in the "month" folder if I'm on a trip for 3-4 weeks, or just for a day, if I'm ... let's say on an exhibition.
It sounds clunky and probably is, but it works for me. It's OS agnostic, (I work on mac os and linux machines at home) it's easy to create backups or copies and move stuff around. All is stored on a big 8TB harddrive and I have several copies of it. (No cloud)