Castlevania 3? Rondo? 
Love 'em, but I love
SQ more.
And really, "kicks the shit out of them" is pure hyperbole, but I get tired of hearing people spewing crap about the game. It's got some weirdness, but in my opinion criticisms against the tornado bit and such are invalid 'cos everybody knows how to do those parts anyway. I have a hell of a lot of fun playing the game every time that I do, and it never gets tiring, and I've never seen it as poorly designed. To date, no other
Castlevania game gives you the open-ended freedom to explore as this game does. It's still linear in a lot of ways, but it makes you feel like you're on an adventure, which is a feeling I've never really gotten from any other games in the series besides the first N64 game.
Dracula's Curse is actually one of my least favorite of the classic
Castlevanias. I love it to bits and pieces, but
I,
IV,
II,
Rondo,
Bloodlines, and X68000 (in that order) are all better, in my mind.