Business related-longest stay was in a Residence Inn for 13 days.
Non-Business related-21 days in a Super 8 (when the house flooded).
Anything beyond 7 days usually drives me nuts as I prefer to sleep in my own bed. Hotel beds are very uncomfortable for extended lengths of time.