I have four main folders, and each describes the folders nested within them:
Lightroom By Date
Lightroom Exports
Folders Non-Lightroom
Raw Takes and Mid-Edit
Lightroom By Date contains folders that are archived work. They are completed shoots. The folders within, named and arranged by date*, contain images that have been renamed and searchable metadata has been added to them. Also within each folder is the related Lightroom catalog. I create a new LR catalog for each shoot, so the finished work is portable and easy to manage if I need to reopen a folder and work on the images again.
Lightroom Exports are folders containing whatever images I exported from a shoot. They have the same name as the associated Lightroom folder, but followed by the word EXPORTS and sometimes a client's name, publication, etc.
Folders Non-Lightroom are if I have exported TIFF or DNG or large Photoshop files, so I can then do further work with them outside of Lightroom, such as stacking astrophotography images, etc. Also they are for when I import a card and I only need to work one image in Photoshop. These are images that I have worked but they don't have LR catalogs.
Raw Takes and Mid-Edit is what it sounds like. It's my first stop after importing cards onto my Mac. It's essentially my "working" folder for all of my tasks before I get to Lightroom - editing, culling, sorting, renaming, adding metadata. If I import cards but I'm not editing them immediately, this is where the raw take goes. It's also where projects go if I'm working on a shoot that will take multiple days.
*My naming convention for individual images and for the folders they go into is as follows:
If I shot photos today (Jan. 25, 2023) of a rodeo, I would create a folder on my Mac named 230125-Rodeo and I'd import my raw take into it. I start with 23 not 2023 because the "20" is redundant. All of my folders and images this century would start with "20..." so what's the point? All I need is 23 (year) 01 (month) 25 (date) and Rodeo (the subject).
The following is done in Photo Mechanic, but the same would apply to Adobe Bridge and any other software that is used for sorting, editing, culling and managing metadata. I import my images into the 230125-Rodeo folder and then I rename them to match the folder. I sort them sequentially by time taken. And I have made sure my cameras all have the time and date set correctly, that way, as I'm doing my edit, photos from different cameras appear in sequence at the time they were taken.
When I rename my images sequentially, I do not start with 001. I start with 100. I want to keep the lowest numbers available for later.
I rename all the images in the order they were shot, so they become 230125-Rodeo_100, 230125-Rodeo_101, 230125-Rodeo_102, etc. After renaming, I do my edit. Some images will be deleted. Some images will be tagged for the second edit. I go through the entire take, tagging all the images I like. Then I start over again, editing just the tagged images this time. When I have decided on the best images, I add a star in Photo Mechanic. Stars can be read in Lightroom, so it's easy to go right to my best work later when I'm doing my post.
Remember that I initially renamed the entire take starting with 100. Now I re-rename just these best images starting with 001. That way, I always know that the images I thought were the best are the ones with the lowest numbers, and they float to the top of a finder folder when sorted by name. I don't need to open an image in Preview or anything else to know that it's one of my favorites, just because of the filename.
So when I open my Lightroom By Date folder, I see a series of folders, each containing finished work, with the most recent folder at the top, followed by the second most recent, etc. If I sort that folder by date OR name, I get the same results. And since all of the images have searchable metadata, I know it's easy to open the main folder and simply search for "rodeo" or "horse" or "cowboy" or whatever, and the images with those keywords will appear in the search.
When I am ready to do my post, I open Lightroom and create a new catalog. It goes inside the 230125-Rodeo folder and I call it the same name. I do my work in LR, export the images to a new folder, send those images to wherever they need to go and then I copy all those folders to my main archive. After I've made multiple copies of those folders on different hard drives, I can erase them off my Mac.
This might be overkill for a lot of people, but it probably takes longer to describe it than to do it. And I have decades of work, so it's the way I've found that I can wrap my arms around a seriously huge archive of files, to do my work and then be able to find the image I want, quickly, often years later.
Hope that helped!