No Overlap should only be turned off when the precise display of overlapping notes is more important than producing a smooth melodic line:
Logic Pro Instruments: PDF