Is this like a computational + memory need? Otherwise one would think something like the framework desktop or a mac mini would be a better choice right?

I need both compute and memory. Video/image processing models take a lot in training. And the bigger the better at these sizes. So it will run trainings for weeks nonstop.