Remember this applies to MIDI as well as audio.
For my work style, I almost always uses Sound on Sound for MIDI (so I can build up a part, like a drum track), but Overwrite for audio (so I can punch in). Of course, there are times when I need to change one or the other of those.