Chrono Trigger has to be the best for me, because a large part of it is sampled from Pink Floyd's The Wall, most noticeable in the trial sequence and "Hey You" playing in the wierd ice-age part
After that, probably the Zelda theme, which is eternally stuck in my head (along with that Ocarina...