In Up the Long Ladder Riker tells Brenna that the ship will clean itself. (Well, good for the bloody ship!) On the other hand, I think it's Data's girlfriend's quarters we see in In Theory that look like the ship doesn't clean itself. I reckon the crew cleans their own quarters after a kerfuffle, to be honest.