For a long time the most amazing one for me was in Montezuma's Revenge (PC). Sure, the levels were… well, not astonishing, but there was this one room that was HUUUUUUUUUUUUGE (for the time). That was amazing. I could feel it, massive! However, it was just a huge box with ropes and platforms (and enemies), so it wasn't distinct architecturally.
What doesn't count: that awesome waterfall in Laura Croft. awesome, but it's not man-made.
A lot of places seem to have tons of work done on them, but they make it so you can only see part of the building or something weird like that. I haven't played the latest Shadow Warrior, but it looked like the kind. The same seems true of the latest Star Wars game, really expensive stuff, it all looks good, but architecturally nothing seems quite to strike, but I haven't played them, so correct me if I'm wrong.
Goldeneye had a few places that might work, but I never played it, so, seeing it from the future it looks repetitive and generic.
I feel pretty safe in saying that Doom only just barely has some architectural moments, due to engine limits. let me know if there's a good one. I at least can recall the level 1 room where there was green ooze or whatever it's called. The designers were clever and added walls that looked like pillars.
Duke Nukem 3D pushed it a lot, but I never played the full version. I'm not really sure much of anything had an impact, architecturally, though certainly places manage to be memorable. The church is an example of a missed opportunity, it was really freaky and sort of built into a building. But who hasn't wanted a jet pack while sitting through a boring sermon, so you could jet out of there?
Tekwar, I really like it. It wasn't a good game, and I only had the super short demo. However, unsurprisingly, nothing stood out. It was quite repetitive. I remember there was a hospital lobby, but I can't really remember what it looked like. It wasn't that much like a real hospital.
tldr what architectural spots were awesome in your experience?
to me, doom & similar are the absolute ground minimum. I remember a tree in Hexen, but a tree isn't manmade. Still, that level of tech had potential. So that's why I chose Doom for the embed.