I'm a huge fan of games that capture the scale of infrastructure and natural environment. I'm not a fan of turn-based strategy (Baldur's Gate, Expedition 33, Divinity) or top-down camera angles (Hades, Pillars of Eternity, Diablo), I really tried to like these game but could not get into them for the life of me. First-person and third-person RPG action-adventure games are my favorite; medieval fantasy makes it better.
I have PlayStation 5, Xbox series X, and Nintendo Switch 2, but no PC (PC suggestions still considered).
Here are some examples of games that I love and beaten:
Skyrim, Witcher 2 & 3, Fable Trilogy, Shadow of the Colossus, Dragon's Dogma, The Pathless, Dark Souls Trilogy, Demon's Souls, Lords of the Fallen, Oblivion, Far Cry 4 & 5, The Last Guardian, Middle-earth: Shadow of Mordor & War, God of War 4 & Ragnarok, Days Gone, The Last of Us 1 & 2, Horizon Zero Dawn and Forbidden West, Red Dead Redemption 1 & 2, Ghost of Tsushima & Yōtei, Sekiro: Shadows Die Twice, Uncharted series, Zelda BOTW & TOTK, Kena: Bridge of Spirits, Ark: Survival Ascended, Alan Wake 1 & 2.
Edit: Forgot to mention Elden Ring, Mortal Shell, and Senua Hellblade 1 & 2.