I don’t track or rank joy like that, but discovering the dark world in The Legend of Zelda a Link to the Past is definitely up there. Just realising the world had this whole extra dimension to it.
I still love dimensionality / hidden depth in games.
I mean, who doesn’t?
Increasingly, I find the answer is in the comments, or not at all