I think we sometimes forget that there are 2 very distinct audiences for our pictures.
On the one hand there are photographers which includes ourself taking the shot. After a while we have virtually seen it all and logistics allowing done it all. So for us nothing is new except taking the shot for the first time ourself. The challenge here is to take the shot trying to capture it the way we want and hopefully improving the shot each time we repeat it.
The other audience is the general public which may include our families. For them many of the same old subjects we shoot are new. How many times have we heard things like "when you take a picture of a ..... it looks like a ....., but when I take it it looks like $@&% !!"
No matter if we are shooting as amateurs or pro's the same applies. Yep I get bored with seeing the n'th picture of a whatever, but will that stop me trying the shot when I see it? No way because I want to see if I can capture that light the way I see it and at least as well as anyone else.