I'll go to a spot until I feel I have a shot that satisifies me. I did 3 coast to coast trips to the Palouse in 2003 to get photos at 2 places that i liked, "Prescott Trees" and "Palouse Powerlines". I would not plan on shooting at either of them again unless I was in the neighborhood and there were highly unusual or extremely promising conditions.
I can understand the desire to shoot close to home and to go to the same location time and time again. It is familiar, and it's also easy. One of the hardest things is to find great spots, and once you find one, if you can make images that are sufficiently different each time you can be very productive. Some locations can change dramatically at different times of the year. And a location that you're familar with, you know the best angle, you know where the sun comes from, you know if the foliage is evergreen or deciduous, you can easily optimise the process and you can look out the window and know what the conditions are at that spot in real time. Also with locations close to home there's more of a personal connection for the artist. On the other hand having 6 shots of the same scene in your portfolio might not be the best thing either.
For me though, I'm always curious as to what is around the next corner.