I love a lot of RPGs but I think honestly only one has made me actually want to visit the world it is set in: Assassins Creed Odyssey (and yes, it is a proper RPG, one of the reasons it is shunned in the r/AssassinsCreed subreddit).
Admittedly I have always been very fascinated by Classical and Ancient Greek history and the whole Mediterranean area pre-Rome, but also that game is still in 2024 gorgeous as heck.