We as a fandom need to discuss more the differences between the Zeldas across the games cause they are fascinating.
Take Ocarina of Time.
Sheik in Oot is very emotional un-available and distant, to the point of coming across as overtly dutiful. Sheik in oot shows up to teach Link songs then ding dong ditches immediately. The one time they had a heart-to-heart after water temple Sheik Cannot Handle and bolts to watch Link from afar cause he cannot having an emotional connection when he's already traumatized from his previous actions as kid leading to the destruction of Hyrule and feels guilt over his actions in what essentially was ruining Link's life.
And that emotional unavailability continues when Sheik is Zelda cause after everything is said and done instead of actually unpacking everything that just happened Zelda justs - sends Link away. She sends him back to the past cause that guilt is so strong that she feels the only way to atone is to have him relive those years to "fix" the problem. Never occurs to her to actually open up to him. To pour out these feelings and this guilt. That they can move on this way. It's part of the tragedy of Ocarina of Time imho. And an interesting contrast to botw, where there is tragedy, the story ends (in totk) with Zelda and Link moving on and building on that new future.