Whenever someone asks me this, I automatically direct them to STALKER: Call of Pripyat. Any game in the STALKER series really.
However, the maps are (relatively) small as compared to the current industry standard, which generally involves gigantic maps that take 20 minutes to traverse, despite being full of absolutely squat.