I'm looking for a Zelda game (I have not yet played) with good 'exploration' of secrets.

[BasilZero]

The Oracle games for sure.

In terms of exploration....its not like the ones you played or Oracle games but closest ones I could think of in regards to the more modern Zelda games is...Skyward Sword or BotW