Sometimes I’m looking for games that give you just that feeling. Right now Surviving Mars and TW: Warhammer 2 are doing it quite well. Looking at them makes me feel the way you described.
Ni No Kuni II, Sekiro, Dark Souls, Bioshock, World of Warcraft, Baldur’s Gate, Icewind Dale, Planescape: Torment, Elex, Anno 1404 & 1800, Operencia, Commandos, Shadow Tactics, Total War: Warhammer, Age of Empires 2, Hegemony 3, Starcraft 1 & 2, Sins of a Solar Empire, Kingdom Rush, Warhammer 40K: Dawn of War, Battle Chasers: Nightwar, Invisible Inc., Sang Froid, Lords of the Fallen, Apex Legends, Call of Duty: Black Ops ? (the last one that had the very warm colored Blackout map), Prey, Quake, Spellforce 3, Victor Vran, Darksiders, Settlers 7
I see a pattern here: Comic vibe (of which I’m not a fan actually. . .) with warm colors - I’m disappointed by myself : ) Or snow! Snow is very important. Others, that have not enough room on the list, are mostly hand-drawn or 2D/2,5D games. I skipped most nostalgia stuff although Quake might fit into that category. There are lots more.
And there are some games that just look too good to trigger that feeling. Mostly indie games that are very much aware of how good looking /stylized they are. That’s somehow not getting to me.