FWIW...I just got a new box and FINALLY conceded to Lord Adobe and now doing the CC subscription model....Noticeable improvement in LR Classic versus LR 6.0 on my Win7 machine. Even then I create a catalog of images from mixed cameras to include maybe 100's of my Sony 7RII 125mb raw files, I actually have had no problems.
Like DD, I also end up with comps in PS that are easily 1.5TB and I have not really had any lag or crashing with the new box.
BUT, AfterFX is and will also be 1000 years too slow to render. hahahaha