It's some German font. I want to say some form of a Fraktur font, but all the ones I'm finding have too large of a serif. But it's definitely a Fraktur or some such font. The little notch in the top of the lowercase L. The diamond-bottom lowercase n. Those are all customary attributes of a Fraktur font. I'm still working on it. Has a French "i" and German lettering.

I think the fact that I narrowed the subtitle font down to Goudy Text (torrented it just now, so be patient) and have narrowed down the family of fonts used for the newer Castlevania titles is a pretty good step in the right direction. The C's all seem to be custom fonts. Working on the US NES Castlevanias too. I think the original Castlevania was a customized gothic font (haven't found anything with those diagonal tops AND diamond dots yet) and I haven't found the subtitle font for Dracula's Curse or Simon's Quest yet.
I will say this: most Italian-style fonts look really good as Castlevania titles, in my opinion. It's just something about the word "Castlevania" itself.
The Harmony of Dissonance's "C" is from a real font, though. I've seen that C countless times.
I'm leaning towards a combination of two or three Fractur fonts or a customized Fractur font. Take the serifs off (or shorten them) and replace the teardrop brushstroke dotted 'i' with a diamond stroke.
The 'D' in Dracula's Curse suggests it's a Fredric Goudy font, to me at least (I'm no expert), but I haven't found the C to match it. Goudy tends to use rounder C's.
Mix and match these fonts and you should be able to come pretty close. Remember there are no fancy serifs, an S looks like an S (not an F), and i's are dotted with a diamond in newer titles whereas older titles had an i dotted with a dipping swiff (dunno what to call it).
http://www.fontspace.com/category/frakturhttp://www.fontspace.com/category/blackletterThe C in Dracula's Curse for all intents and purposes (is that the right phrase?) is a fraktur C with the fancy vertical line removed. I gues there are also Rotund and Textura (or something) styles which are often very similar to Fraktur, but most of the Castlevania fonts appear to be Frakturs. (it's a categorization of a font, not a name, although there is a font called Fraktur).