Yes and NoDepends on the use ...
The cartridge angle to the groove is basically the same in both. If you trace a line between the pivot point of the arm and the cartridge shell, all those arms maintain the same angles through the entire playable area of the record. Only a linear tracking arm (or maybe the old Garrard Zero tonearms that changed the cartridge angle as it moved across the record) will maintain the correct geometry to match the way they were cut.
Now an S arm will generally have more mass and may give a bit more rigidity and the higher weight might help tracking in a club.
So, if you're going to scratch .. "S" shaped .. otherwise it's up to preference. My home TT is a linear tracker (Yamaha PX-3).
Fixed headshell arms have an offset head that allows for the cartridge to be angled enough that it minimizes tracking error. Removable headshells, which are absolutely necessary for DJ'ing, usually do not allow for this. When you use a removable headshell on an angled or "S" shaped arm, you can still get the tracking error pretty low (at the two null points), but when used on a straight arm, tracking error on the inner grooves of a record will be quite high. This is actually made worse since the pivoting straight arms on turntables designed for DJ'ing are extremely short. Because of this, a straight pivoting arm should only be used for DVS/Time Code.
Here's a good explanation of this. Imagine trying to get the "two null points" by twisting the cartridge mounting screws in the elongated slots of the headshell - which is what you would have to do if that headshell was attached to a straight arm -