I try not to sit the same stand twice a week unless there is a very good reason. I don't absndon the spot, just let them rest. If I saw nothing there, a different time of day or a different part of the season or just a different day can pay off. If it's a good spot I'll visit it throughout the season. I have a few stands that I hunt whenever we have an east wind, even if it's a few sits in a row because there is no way a deer can get downwind of me and entry and exit are extremely low impact. I have shot opportunities there almost every sit, but I'm usually waiting for the right deer. I have hunted spots that looked perfect and never seen a deer from them, no matter what. I usually will pop in once a season but have learned to just give up on them.
So I guess the answer is that it all depends.