The photo-real painting movement ended after a brief period in the late 1960's for exactly the same reason - it was boring to look at.
Actually the movement is still very much alive and highly collected... People admire the technique. I used to teach a class in photorealistic painting methods at the Art Institute of Houston.
And as far as Realism in games... Eve Online... Space game... it looks like it should... space.