Mirror's Edge is the big one, it's like being inside an architect's maquette.
Yeah Half Life 2 had that Eastern Europe in distress vibe. Was pretty cool.
Assassins Creed during the Crusades and Renaissance was also cool
How could I forget Assassin's Creed? Can you count the ship environments as architecture? The "sync/viewpoint" spins were one of my favourite parts and showcased how much work had gone into the world.
Deus Ex: Human Revolution had some beautiful architecture. The original Deus Ex was very good for its time, too -- the architecture really supported the game, even if it looks like crap now.