Tenpenny tower - Fallout
Want a decent room in this sh*t of a waste land? look no further than Tenpenny tower.
You too can afford a room there for the low price of blowing up Megaton
SOTC and Ico are both also beautiful looking PS2 games
Going older, The Zelda snes game had a simple yet great Art style that was very immersive
The art style was so good it becamic iconic for the Zelda series and even influenced other rpg titles in future consoles.
like 80% of GBA rpgs look similar to this Zelda game.. Hell, between this an Earthbound Nintendo stumbled upon one of the most effective and immersive ways to use sprite artwork.