Bad game design

I have always claimed that Ocarina of Time is a well designed game. When people whined about the water temple I always came to the games defense. However in my quest to collect all the Golden Skulltulas I come across something that I can't call anything other than unforgivingly bad game design on the level of the broken game design you used to see on the NES.

As a kid I was very interested in one lonely tree along the fence at Hyrule Castle, close to where you find Talon sleeping. The reason for this was that the ocarina sounded different when played close to this tree. How I even figured this out I'm not sure. This oddity seems to have been fixed in the Virtual Console version, but have come to find out that this tree holds an even bigger secret. If the song of storm is played close to this tree a secret hole will open up in the ground. In which one of the Golden Skulltulas can be found.

This is so completely random that I have no idea how anyone could ever figure it out. Why would the rain make a hole appear in the ground? And why at this completely random spot of all places? It is completely impossible to figure out without a walkthrough. If there was nothing of real value in the hole I guess it could be excused as a cool secret but hiding a Gold Skulltula in there is just a big fuck you to all those players who try to collect them all.