I am not sure I can really help here other than to add a very important caveat on the overall reliability of spot welds.
I am no welder, but I do have considerable experience with spot welding in an automotive assembly setting and I have a patent for electronically controlling a spot welder in that environment so its not like I'm clueless like I am with other welding processes. It's really that spot welding a car body together in a factory setting with giant spot welders is on a whole different scale than a hobby level machine.
I agree with
@mikefrost's comments. At least for the big machines, the challenge is controlling the timing and the current so that the spot weld process itself doesn't just send a molten nugget flying around the area with a hole in the part. Pressure needs to be enough to allow high current but not so much as to pinch the molten nugget out.
In my mind, the biggest problem with hobby spot welding is prolly the same one as in the big factories - quality control of the nugget. In particular, how do you know the nugget is a good one? In the factory setting with repetitive welds, we did destructive testing of an entire car body every so often - every two hours or so. It had to be often enough to catch problems but not so often as to waste production. My invention monitored the weld nugget formation in real time to avoid the need for inspection and destructive testing. This can't be done in a hobby setting.
Another way to address the quality control issue is to have 4 times as many welds as needed so you can afford to have a few bad welds.
Anyway, the only real value I can bring to this discussion is this: Don't assume that a good looking spot weld on the surface is actually a good weld at the part to part interface. Cold spot welds are a fact of life in the best of environments even under very carefully controlled conditions. By all means, test them to the extent that you can, but on mission critical joints, I'd prolly recommend a more traditional welding method where you can trust your eyes to assess the weld quality reliably.
Just my two cents for what it's worth.