The closest I'm finding online is Leon's theme. It does have a SotN heavy piano melody with ghostly arias over it. It's good but I wouldn't call it as catchy as the more blunt NES simple riffs.
Castlevania
Oliver Evans
William James
O MY RUBBER OPINION.
Jaxon Edwards
Wow are you a chameleon or something? Cool!
Ryder Kelly
Im not ashamed