I like two 5 to 6 day trips a year. I can't be gone from work for long periods of time. However, I do get 6 weeks of vacation so I can do a lot of mini vacations.
We've only done stays of 5 or 6 nights, and usually have things we hadn't gotten to (especially food, lol!). When/if we go back, I would like to try lengthening it to 10 days or so (we lose a day each way to travel as well).