Chores and curfews, no (although they often have rules that you have to be "quiet" after a certain time). Cleaning fees, yes.
Why would anyone use them?
Honestly I can only think of two good reasons.
You want to stay somewhere really out of the way where there aren't any hotels.
Sometimes when you are 5 or more people it can be cheaper to rent one large apartment rather than 3+ hotel rooms.
I know sometimes people also use them if they're going to be staying for a several weeks and want a real kitchen, living room etc.
Other than that, I would never use Airbnb. And even in the cases where Airbnb would be useful, I would seriously consider booking with another company before using Airbnb.
Full disclosure. Never personally had a problem with AirBnb, but heard enough stories and know enough people who have.