I like a selection of the recurring melodies that have been used since the early CV games (Bloody Tears, Vampire Killer).
Nocturne/Symphony has the best soundtrack since it's the biggest, most complete, mostly originally, and orchestrated from the ground up. It has a nice progressive-rock angle to it.
Most of CotM's tracks I liked aren't original to the game. Quite a few were lifted and dumbed-down from the N64 Castlevania games. The rest of CotM songs I thought were so-so.
But I like the original music made for the N64 games a lot. Some of the remixes in it were also nice. I liked its "haunting" style, I just wish there were more tracks.
Lament of Innocence was moody and forgettable. Not even so-so, just forgettable.