People in CS can tell on their profile which is the maximum number of nights they want to host, so I think that filtering on that you will be able to identify the kind of hosts that fit your travelling policy.
In my personal experience, being member of CS since the beginning of 2009 and living in Pisa (so, a lot of requests every day), people ask for 1 to 3 nights so, yes, it is unusual to stay for more than 3 days. Of course this can depends on the nature of the city: Rome is not visitable in just two days while Pisa is.
Moreover, it is not unusual for people to ask to be hosted several times, usually at the beginning and at the end of a trip. That's what happendhappened with some americansAmericans I hosted when they landed in Pisa and at the end of their travel through Italy before taking the plane back.