We have done lots of different stays, from as little as 2 nights to a much as 12 nights. I find our trips that are around 9 nights to be the perfect amount of time. It gives us enough time to be able to relax and enjoy ourselves at a slower pace, yet it's not too long.

The one time we did 12 nights the last few days started to feel repetitive. And we really felt we had been away from home too long. We were so ready to go home by that point.

On the other hand, even a full week(7 nights) sometimes just doesn't feel like enough time and we aren't ready to go home just yet. So for us 9 nights is perfect!