I played LTTP on the gba port, so I may not of had the same experience these elder gamers had of the NES LTTP. I'm going to say it straight; my experience of LTTP was terrible. It was one of those games which you had to be enticed to play by previous zelda games. I found myself growing bored of it within 20 minutes or so, thus why it had only been played once and then sold on eBay within the span of 5 years. I don't really have any fond memories of the game because it made such a small impression on me - the only thing I remember about it is waking up and then having to aid princess zelda in the hyrule dungeons.
If you're planning to play it on the basis of playing every zelda game, then do. However, if you just want to play it to kill time then I'd suggest not to. My most memorable game boy advance game was without a doubt Minish cap, so I'd recommend playing that.