Let's see...
Straight type always has the advantage that the tube is easier to make which might enable some extra optimizations, like better materials, more rigidity etc.
It also has the advantage that is inherently laterally balanced.
The disadvantage is that most straight toneams have no removable headshells.
J-type often allows removable headshells,
but it is laterally unbalanced, thus it requires a lateral compensator weight.
S-type is less unbalanced than the J-type, that's the reason S-type tonearm was invented. It will still require a lateral compensator on many cases, unless one uses the exact type headshell and exact type cartridge the designers intended.
In theory the straight type is the best starting point for maximum sound quality. In practice it depends of the implementation.
Straight tonearms i have had the RB220 and RB303 (Rega) tonearms, and I quite like them. My linear tracker (SL-DL1) also has a short straight tonearm, as did my former SL-10. I find these technics linear trackers sound good, perhaps with a bit less bass than I would like.
S-type I have the SME 3009/III which I find excellent, and besides that one, the tonearm on my Sony PS-4750 which so far is sounding very nice (i need to listen to it more).
J-type i have the SME 3009 II non-improved, which so far i'm finding very sweet sounding.