Ah, I still remember that feeling as a kid the first time I got all the medallions and pulled the master sword from the pedestal in A Link to the Past. Good times.
A Link To The Past had the most magical feel of any master sword, I think.
Ocarina of Time was great, but it felt... almost like a religious artifact, if that makes sense. Whereas LTTP was just this sword in this exquisitely beautiful little grove, deep within a magical forest... it had a feeling of a legend being born that no other game has ever quite touched since. At least, for me!