This kind of work made 64GB RAM look tiny: New from Tangent Animation: Next Gen. Is this Bender?
A different industry than yours, and different needs obviously. You can look at the datasets by Disney to get an impression what scene sizes in animation work can look like: https://www.disneyanimation.com/technology/datasets
Personally, I never put much into the “spend lots of money on a machine that will last me for a long time” idea. Buy what you actually need, don’t waste money on things you think you might need.