TL;DR: Any “last big secret” has not been found, and all signs point to there not being any.
http://goldeneye.wikia.com/wiki/Citadel
It wasn't really an intended secret. It sounds like to make it accessible, a player had to hack it in, and to make it playable, another player had to contribute clipping information.
Sometimes the journey is more important than the destination.