Directory structure pattern: "YYYY/YYYY-MM-DD-tag1-tag2/xxxxx.jpg"
Should the files be renamed on copying from the camera? If necessary rename only once -- before working with the files, importing them into darktable/digikam.
Do not use stars, flags, color labels, use text tags instead, store tags in .xmp files.
Use two tags like "edit" and "edit-TIMESTAMP" when tagging photos for a special temporary/one-time task like "print" and "print-20200109"... Keep those tags to track history.
Tag photos as "printed", "shared", "published", and with a the same word but with a timestamp "printed-20200109" etc.
Tag photos to delete with "delete" tag, rather than using digikam's delete function.
Put videos into a subdirectory.
Mark for culling:
Certain to keep: "pick-best" > "pick-good" > "pick-keep"
Tentative: "pick-uncertain" > "pick-bad" > "pick-delete"