Re: " looking for the best way to keep the timeline drives and their backups lean once clips have been chosen or after finishing a project"
There is no easy way to do that on the current product. DaVinci Resolve has and I think "Classic" FCP 7 had clip trimming during consolidation. The current FCP does not have that. Doing bulk trimming with the Resolve media management feature has historically been very buggy. I tested it several times on version 16, and it caused widespread data corruption. There are current reports of continuing problems on version 19. That may be why Apple has been reticent to add that feature -- *bulk* "no render" trimming of Long GOP formats is inherently risky.
With FCP the fastest workflow is normally to import all content using "leave files in place," then in the Event Browser, rapidly skim and mark favorites, rejects and keyword ranges. It is much faster than doing two-pass curation, once at the file level and again after import to FCP. But if you want to copy untrimmed media within the library, that will take more space.
That said, Quicktime Player can do "no render" trimming and splitting of individual video files. It's not limited to just trimming the head and tail -- you can cut out multiple pieces, reorder sections of the clip, then save the result without re-encoding. Given your criteria it might be better to process the clips with Quicktime Player, then import the curated results to FCP. For details, in Youtube query on "Easily Trimming Video Files With QuickTime Player."