My initial thought is either Majora's Mask or The Minish Cap.
Majora's Mask has a ton of sidequests and you'll be resetting the three-day cycle numerous times in order to do them all. There are also a lot of heart pieces (more than any other game I think) and the masks, some of which can be...