You can almost tell how old the responders are in this thread... If you live long enough there will be quite a few "magical moments" from different genres spread over decades of your life. My latest is Nik Bartsch's Ronin "Llyria" on ECM label. Quite a departure from the "magic tune" of my teen years of BoneyM and Eruption ;-)
Chronologically there was Tchaikovsky 1st Piano Concerto (my parents dragged me there, kicking and screaming!) then Here Comes The Sun, Lady Jane, and such, then (oh, Boy!) The Wall, ...
Miles and the whole of jazz got to me only after discovering hi-end, go figure! Classical thru lo-end is OK with me, but not jazz, magic happens only through decent playback.
If there is one "magic" tune I go back to, it is Brahms 1st under Bohm and Wish You Were Here. Oops, its already two! :-)