I never really last more than 3-4 nights at the same place. Even if I travel somewhere remote like the Maldives or Seychelles, I like to check out a couple of properties in the course of a week.
The exception to that is when I'm traveling with my kids and its tough to move around so we tend to stay at the same resort for 7-14 nights.