I rank Castlevania 3 well ahead of both of these, and Bloodlines ahead of SotN. SCVIV is also well ahead of SotN as well as Rondo.
But CV 3 stands tall to me, in it's day it was a game with just the right difficulty and a ton of replay value. I've played SotN so much in the past honestly that I'm now bored of it and retired my PS1 copy to just part of my collection. The version on DXC I ran through as fast as possible, I mainly bought that to own my first legit copy of Rondo at that time (later got it on VC as well for good measure).
SCVIV didn't take me long to 1 life through first and second quests, something I can't even do in CV 3 (much more difficult), or Bloodlines, but nearly pulled off in CV1 (a 2 life clear).