From the original main theme from The Legend of Zelda, all the way up through classics such as A Link to The Past, Link's Awakening, Ocarina of Time, Majora's Mask, and many more!
True. The real theme is just a generic piano followed by silence. I love Botw and Totk, but I feel like the soundtrack is very "shy" or embarrassed to appear in many parts. However, the village themes are amazing (Especially Rito Village and Hateno Village)
Funny how majora's mask out all the 3d zeldas is the only one to use the main theme for it's overworld. Arguably the game you would expect to use it the least.
It's disappointing that you explore the biggest and most lively Hyrule in the history of the franchise and the theme is generic piano notes followed by total silence :/