Since there has been a "poll reset", I voted this time for Harmony of Dissonance.
Not so much for normal mode, but hard mode is where that game shines. Great level of challenge. I also love the atmoshpere throughout the game with the graphics and music. Some of those boss fights are really cool, and I love the merging castles thing. The music is consistent and compliments the rest of the game well, although I do wish they had made alternate versions of the same tunes for areas in Castle A and B. In any case, it's earned a place as my favorite Castlevania for now.