As far as the Castlevania series goes, I think Castlevania II: Simon's Quest will always be my favorite. That was the game that introduced me to the series, and I think it improved upon the original quite a bit.
And yeah, the music in the Castlevania series is easily some of the best you'll ever find video games. No doubt about it.
__________________
Talent, vigor, drive...
You'll eat peanut butter the rest of your life.