Well, when its both good and of something familiar, we may not recognise it as CGI at all. We mostly notice the bad examples.
For example, there's a bit early in The Ninth Gate with a library in a skyscraper. One of the characters mentions getting vertigo from the view from the floor-to-ceiling plate-glass windows. In fact, the view is CGI, but very simple, with almost no movement and just a few distant office lights turning off.
Another example is when a stunt is done on wires, and CGI removes the wires.
There's a clip I found convincing the first time, but it got used in trailers which were repeated endlessly, and it didn't stand up to multiple views. For the kind of reason you go on to mention: the physics looked wrong, the lighting didn't quite match the surroundings; I believe motion-blur was a hot new technology that they used, but maybe that wasn't quite right either. It can be hard to tell why it looks wrong, just that it does.
Sadly, I've also seen things in real life that looked like implausible CGI. We may sometimes see CGI where there is none.