It's something you have to accept I suppose, but when you're taking photos for a living there are going to be times when you're not necessarily taking the photos you want to.
It's something that occurred to me a couple of days ago, when I was editing some photos I'd taken a few weeks earlier, and while the shots were good (you'd worry if you were editing bad shots...), they weren't getting my pulse racing.
There are times when I'm on a shoot and I've taken a picture and just known that I've had a great image - and haven barely been able to contain myself in terms of getting home and getting that image fully finished. I love that feeling of excitement - and I don't know that I've ever taken a shot like that and got it home to find it's not as good as I thought. I live for that feeling...
It's a selfishness you have to overcome sometimes, but there will be times you're on a shoot and you know you've got the best shot you can get in that situation, but it's not the sort of shot you're going to look at in years to come and think 'wow...'
That's why whatever you do, whatever kind of shoot you're doing, you have to try and keep things fresh - even if you know the shots are never going to be used, you have to try something a bit different or take a couple of shots that maybe will get your pulse racing. It's also the reason why personal work is so important, because you're not constrained by a client's brief or expectation and you can do more or less what you want and take the photos you want to...
Just make sure it's always fun and you enjoy whatever it is you're doing - if you're not, what are you doing there...?