Meta analysis, damage optimization, cooldown tuning, investment priority.
The Water Temple is not hard. It is badly signposted, and on N64 it makes you open a menu roughly two hundred times. Once you understand that the whole dungeon is one vertical shaft with three water heights, it collapses into something you can clear in under an hour.