Hello Greg, I've just been through the setup of a new computer so some of this may help. I refuse to have Adobe software on my computer. Every time I've had it there I ended up feeling like I was being choked with an invasive weed.
This is a totally Capture One workflow and based on some patterns suggested by C1.
I have a master catalogue into which everything
eventually is imported. When I shoot or have a project or travel somewhere I set up a session - separate to the catalogue. I import to that session - or shoot in that session if tethered - and apply adjustments, keywords etc in that session. I keep some adjustment pre-sets that I use when importing to set meta-data and I keep a keyword library. On longer trips I have an import set up that creates a finder folder for each day of photographs. I drag and drop those folders into the session favourites area of the session as they are created so that they are easily available. It lets me use an approach like "Tuesday, that was Kyoto so let's add a "Japan|Kyoto" keyword to that folder of images.
Once I have finished active work on that project or trip I import the session to the master catalogue so I only have one place to search and find images.
All Capture One catalogues and sessions live in one top level folder - divided up by further folders depending on whether they are imported into the master catalogue or not. Once imported to the master catalogue that is the only place an image is worked on.
On the road I have a routine where I import the day's pics, so they get presets done to them and the folders created. I also do a first pick through of the images and get rid of any black frames or other obvious crap. Then I run a backup to Backblaze B2 and another backup to a local very fast SSD for the whole C1 storage top level folder. For those backups I use QBackup and I also have scheduled backups to those locations written as LaunchAgent plists so they run every 3 hours. If the laptop doesn't have network or the external SSD isn't connected, then the scheduled backups fail gracefully and run the next time they are scheduled. I tend to run a backup after any editing session as well. It means I don't lose much and QBackup is smart about dealing with deltas. In addition a continuous sync runs to my Synology NAS back home. When I travel the laptop and the SSD drive are in different bags - one in the cabin and one in the hold. I'm not paranoid or anything...
I also have Resilio Sync running on that master folder to various other computers. It's a wonderful piece of software to create your own personal cloud and very efficient.
My biggest issue is that the C1 master storage is going to have to move from my local SSD in the laptop to a large, fast, small, directly attachable storage at some point soon. I can't effectively run from the NAS - neither it nor the network is fast enough for that - and the local internal SSD is not large enough. So quite soon the working sessions will be on the internal storage and the Master on a directly attachable Thunderbolt 3 storage. I haven't decided just what yet.
Because I don't use Lightroom I can't do a comparison but this works for me. Hope that's of some help.
Mike