Ouch, 4TB makes Lightroom pretty much a non-starter. The monthly costs if you put that all on Adobe's servers would be exorbitant, and they don't (yet) offer any sort of tiered/cold storage option. You could, however, dabble with it and upload chunks of your catalog to see how it feels. Note while all files you want in Lightroom do have to be uploaded to the cloud, it keeps, or at least gives the option, local copies as well, so editing isn't normally dependent on tediously downloading photo after photo.
John, while I doubt the Lightroom team consciously decided 'hey, let's make an Aperture clone!', they were no doubt aware of, and influenced by, the design and evolution of Aperture, Photos, and Capture One. It's a small market, and tech companies have a long and proud history of cherry picking competitors' best features (or being 'inspired by' if you're feeling more charitable). What I meant is simply this: Lightroom -- and God, Adobe's made the naming confusing -- eschews two of Classic's fundamental concepts: the modular layout, and the bifurcated files/collections organization.