In my family and circle of friends it's completely normal to help out with the cleaning when you stay at someone's house, to sit and do nothing would probably get a few raised eyebrows.
The difference Titanias is that in this case it is the host who wants to sit and do nothing, and the guest is the one insisting on cleaning above and beyond the party clean up.
In my family/friendship circles it is also normal to help clean up when you're staying with someone, but only things the host asks you to do or that you offer to help with, and definitely not to the point your host has to repeatedly ask you to stop!
It was my nephews birthday a couple of weeks ago, my brother had a party at home. My mum and dad had offered to have all the grandkids for a sleepover so once they'd left my sister and I helped my brother and SIL clear up the house on the promise of a chilled night in hanging out once we'd finished. We cleared the rubbish, wrapped up left over party food, washed up the cutlery and crockery used, hoovered up party food crumbs not that the dog had left many behind , tidied the toys away, took all the present packaging out to the bins/recycling, wiped down surfaces and generally tidied up the kitchen and lounge.
We didn't use it as an excuse to get the bleach and marigolds out and give the house a deep clean, or start organising wardrobes, or scrubbing bathroom tiles ... we just did what was necessary to get the place back in a "normal" living condition and then all agreed we'd got the place back to normal and could call it a day, order pizza, open the wine and fight over what movie to watch.