Funny that you mentioned Tears of the Kingdom, I actually spent a few weeks fully exploring the surface and the depths before doing the first temple. Zelda is one game where I think avoiding the main quest makes a lot of sense considering how the game just ends if you complete it.