That's a good question Willie, I too am a DP user and you probably know that DP has that great feature of V-RACKS where your VI are loaded in parallel and using sequences you can write new cues without having to reload a DP project and your whole template. That's basically what we called a static template.You can also have a static template that is loaded on slave computers.
I'm actually doing this tech work for a busy composer. He doesn't like the idea of running everything from his main computer. However I do believe depending on the needs and size of template that it is doable on one computer.(I am a composer / DP user myself and currently running everything out of one computer although smaller template but I do salivate at the idea of having everything at my finger tip)
For his rig, the main requirement was that it had to be portable. He wanted to be able to grab his laptop and 2 MAC Mini and have access to pretty much the same template on the go. Hence the 2 MAC Mini route. I heard on Motunation forum people claiming it is more efficient to run your VI thru VEPRO on the same machine rather than just loading them in DP. I am not convinced at all and will need to do further testing but in a case of slave computers VEPRO is a must.
Furthermore I'm no expert but despite the fact we can pack and use a lot of RAM these days, there is also disk access and CPU concerns. Not sure if you max out a 96GB RAM computer you might run into streaming problems or other CPU hiccups. Again depends on how much stuff you are triggering what other processing you are doing but in case of big orchestral type sequences that could be an issue perhaps. That's why many composers prefer to split the workload. They tend to go to the most traveled road and prefer to play it safe and avoid any tech problems.