Both employers and employees should be courteous and provide two weeks notice. That may still translate to, "This is your last day, but we will pay you for the next two weeks."
So in my opinion, the answer to this is highly dependent on the employer. If the employer is reasonable to people when letting go of them, then the employees should show the same respect. If the employer does not treat people well on the way out, then the social contract is broken.