There's plenty I guess, but the one that came to my mind reading this thread was reaching Anor Londo in Dark Souls. Anor Londo in its entirety is hella memorable, as well.