It has a very clunky UX for this. But it actually has a lot of useful features for organizing large amounts of photos. There's a guy Bruce Williams on Youtube who has been doing tutorials on Youtube for Darktable for many years that has many relevant videos on this topic. But you can do rule based collections with filters on tags, camera type, and whatever other meta data is there.
It's probably a bit different from what you are used to and IMHO it's over engineered and there are some bad ideas for usability that never really got addressed and are made worse by the developers just putting buttons and controls in all the wrong places. But once you get over that, it actually does have a lot of powerful features for getting organized.
There's actually a fork of Darktable called Ansel that addresses a lot of the UX issues that has been in the works for a few years. The creator of the fork got annoyed with the level of indifference on this topic. There were other reasons as well (he was the creator of the filmic module in Darktable). But most of his UX work at least looks to me as something that the Darktable people might consider adopting.
It's like saying Microsoft Word is bad as an IDE. That's because it's not and IDE.
And Darktable is very explicit that it is not for photography organization and collections.
Also, an aside. I would love an image editor that would let you build your own chain of editing modules in an arbitrary order. Like audio plugins, with the ability to have more than one instance of each one.
This is especially true for professional workflows. I do wedding photography as a side hustle, I shoot anywhere between 15 to 20 weddings/year + a plethora of other sessions (family, portraits, etc.).
The asset management (and plugin ecosystem) are nearly just as important as the RAW processing tools itself. Lightroom (Classic) is even wired up to my gallery delivery service (Pixieset) + ImagenAI for first pass edits.
I've tried and used Darktable in the past. It's already completely capable of being my RAW processor, but it's everything else that's missing that makes my end to end professional workflow possible. The processing/editing tools was never the problem that keeps people locked into Lightroom. It's the decades of plugin development & the asset management features.
But when I switched to Darktable, I didn't really miss it.
I have a simple organization: Year/description/YYYY-MM-DD/*
(So 2026/yellowstone/2026-06-01/*).
In the end, what matters are the files I export to JPG. It makes sense to use a separate photo organization tool to manage those.
For me it was always just folder based. For example YYYY-MM-DD - Eventname and then have sub folders like raw or export.