Don't forget Rareware's games on SNES and N64, the music in those games is insanely good and they managed to pull off excellent visuals at the same time!
On the N64 Rareware also made extensive use of dynamic music transitions depending on where your standing in an area (Like the Bazaar in Skyward Sword) which I still consider to be a very nifty effect that hardly any game developers use anymore :/