After watching Redemption I'm trying to think of all the episodes where a character resigns or comes close to resigning. So far I can only think of Measure of a Man. Maybe Insurrection too when Picard takes off his uniform and goes rambo.
I'm also curious, with Starfleet being somewhat military-like, if resigning is always allowed? I wonder if they could have rejected Data's resignation.