SFX vs ATX power supplies

What SFX, SFX-L, and ATX actually mean for case compatibility, and when each one is the right call.