I get tired of American movies and sitcoms always taking place in New York or Los Angeles, to the point where I have a special appreciation for shows set elsewhere.
I can say this is similar to viewing of British sitcoms. I don't get tired of seeing London, but I appreciate the rural feel I get from seeing other parts of England, whether it be Summer Wine, Doc Martin, etc. I always enjoy the As Time Goes By episodes in Hampshire, although I assume they are showing a gross exaggeration of the area. The same can be said for Ballykissangel, likely good that it didn't take place in England.
So I doubt I would ever get tired of seeing Yorkshire in newer sitcoms. There is a lot to work with there......all the hills, creeks, small towns, woods, etc.