I have commented on many occasions how SCV IV is still a game I can play over and over again repeatedly without once getting tired of it, and how a huge factor in this enjoyment comes from the musical score. It took me a few years, but I finally nabbed a copy of the soundtrack album and it's treated with utmost reverence on my CD shelf. - Has its own private space and everything. Yes, it never fails to impress me just how much pathos the game programmers were able to pump out of the SNES's audio software. The end theme (I will always faithfully refer to it as "Awakening Earth" on my playlists) is a beautiful, haunting, and deeply emotional piece that has not quite been topped in the series as an ending theme. -Though CV 64's grand finale cues and "Repose of Souls" from Circle of the Moon certainly come close.
Surprisingly, "Theme of Simon" does come off as one of the weakest songs in comparison to the rest of the score. But it felt like an immediate Castlevania-flavoured tune the moment I first heard it. It took a few years until the arranged version for Castlevania Chronicle really took the piece and blew me away with a properly fitting, heroic treatment. The melody itself though is unforgettable. Definitely ranks up there with the classics for sheer catchy-ness.
All in all, this is a soundtrack that I think will forever be regarded -- and rightly so -- as a milestone of video game scoring, a spot-on mood enhancing score for Castlevania, an ideal representation of the mythos this series stands for, and a benchmark that games in the franchise do and should aspire to. Bravo.