Axle joints are used when there is a moving component such as a gear or a sprocket needed to be connected. In that case, the axle joint is the only way to allow motion for such gears. The axle joint should be avoided if it is not necessary as it has high friction, high slop, and is also bulky and heavy.
Courtesy of Team BNS (Link)
The basic screw joint is a joint that could be used when there isn't much space for a joint. It only requires a thin spacer, screw, and a Nylock nut. The characteristics of the basic screw joint is that it has low friction but high slop. It also slowly damages the metal as the spacer only distances the two metal pieces by a little. This can be fixed witha larger spacer but that would sacrifice the compactness of this joint.
Courtesy of Team BNS (Link)
The double bearing screw joint is the most reliable screw joint and should be used if space and resources allow. It does not sacrifice slop for friction and so has medium friction and slop. Although it is also bulky and heavy, it is a decent multipurpose joint due to its reliability.