Deku Nuts in Ocarina of Time. I've never found the enemies in this game difficult enough that I needed to stun them.
Piggybacking off that, the Ice Arrow in the same game was also useless, and what was worse about it was it had a whole mini-dungeon centered around obtaining it...