CGI had some very big wins early on. Jurassic Park was made in 1993, and still looks really good today.

Terminator 2 was two years earlier than that. It didn't try to be photorealistic, but it used the available tech in a way that was visually interesting.

Maybe we're waiting for a filmmaker to find the right use for it. Apparently this isn't it.