Not CGI but I remember being in absolute awe when games like Ninja Gaiden and Golgo 13 would give you a lengthy cutscene. My friends would be like "Skip it" but for me, it was just amazing to see a video game presented in such a way. Like BraLoD said, it was a reward.
Since then, I've always leaned towards more cinematic games. I do prefer "in engine" stuff these days so I don't mind if CGI goes extinct. It used to be amazing but now it just looks out of place.








