usually it's a combination of getting stuck and losing the drive to continue playing, as a result the only Zelda games i've beaten are Link's Awakening, Ocarina of Time, and Breath of the Wild, meanwhile NES zelda, Link to the past, Seasons, and Majora's mask remain unfinished for me