My theory is because the act of tidying/cleaning/etc can be quite rewarding: you know you've taken a bad situation and improved it.

The reason it doesn't work in your own house is because you know it's just going to revert to being a mess again. With somebody else's you do your good deed, and then leave, without seeing the rot re-emerge.