Key fact
If you need speed for a task like video editing but can’t afford an SSD big enough for everything, use a small SSD as a project drive: copy files over from the hard disk while you use them, then copy back. To really maximise performance, use an SSD other than your Mac’s startup disk.