I'll try to not sound boring, but there are some Famicom games whose music is astounding (even with the so limited hardware)
Captain Tsubasa 2 (The most strangest conconction of genres: Soccer and RPG)
Getsu Fuu Maden (samurai adventure game)
Wai Wai World 1 and 2 (fan service for Konami nuts)
If you haven't tried them, I invite you to do it (thru the usual ways )