That would depend on a multitude of factors including the individual. For me, 2 weeks wouldn't be too long, but that gets trumped by wanting to spend what limited time I have on other locales due to the distance traveled. I met a young man who was visiting Australia for 4+ months, perhaps in his case 2 weeks in Sydney may not be enough. Oh to be young, unemployed and have sufficient funds to do so. Now he was staying in hostels, which left my pool of accommodation choices a couple decades back.