There are a few that I find really cool.

The "bullet time" in the max payne series was very enjoyable to me. Dodge-flying around enemies while bullets hit your last position and all looking like you are in the matrix movie? Yes please!

Then there was the flying in GTA5. The controls and "feel" of all the vehicles are very good, but flying is really implemented in a great way. Its by no means to difficult to learn (like a real simulator), but has a pretty high skill ceiling. To really "fly beautifully" you have to know your shit. And thats not even counting fighting air-to-air or air-to-land. It's beautiful.

Also I'm a sucker for all atmospheric games. Bonus for being dystopic. The System-/Bioshock series, Stalker, Fallout, Cyberpunk2077 and many many more. Disco Elysium. Some games really are art in its purest form. Still entertainment, but art at the same time. I remember the first time I entered Novigrad in Witcher 3, not even on a good graphics card. Such a vivid, "living" town, with logical alleyways, bridges, beautiful architecture, soundstage just amazing, ... I think to this day no other game has surpassed W3 when it comes to creating a believable city. It's just art!