I'd give Minecraft a shout, I'm very picky with how games look and I've reallly fallen in love with it.
I quite often just watch the sun (which is a block
) rise from a nice spot, sad yeah I know.
GTA IV in full flow, walking through the City is stunning as is Mafia II in much the same respect. I'd also put WoW out there, if you just want to watch the world go by, sit in a capital city with things on high and just watch people mingle.
(I'm often playing more then one game or have a game open so I end up watching things pass by in games, I've never really got fed up of watching the world pass me by virtually in those games, WoW is funny because you see some really daft stuff happen and much the same for GTA IV when people randomly get ran over or chased by the police)