For the most, part vacation destinations are good for about 3 or 4 nights.....then it's time to go home (at least for me).
Name some spots where you can stay longer.
LA
I can do Vegas without getting bored, as long as my paper is right.
A couple of spots come to mind for me:
NYC
Miami
LA
Dubai
London/Paris
I have family in Dubai & London/Paris, so it makes it easier to stay longer than a week, but for NYC/Miami/LA, there are tons of things to do in each city, and I don't mind speding more than a week in each location (I've stayed in Miami and LA each of the last 4 winters to get away from the crummy winters here in the NE.
I have a job where I can work remote from anywhere, so I spend 2 weeks in Dubai during the end of December through New Years, then I spend about 7-10 days each in Miami and LA during Jan and Feb to get away from the snow and cold of the NE. I might move someday to either city to permanently get away from the winter weather forever. I also work from Europe during the month of July each year, so I'm posted up from London or Paris staying with fam. This year I spent about 10 days in the South of France during July. I'm planning to spend a month in Portugal next summer, and maybe go to Greece too.