I don't know how good CV2's reputation really is. It's certainly a bit different from all the others (Super Castlevania IV is really kind of a remake of the original CV.) That's what I like about it but the goofs and flaws are a bit hard to ignore.
Oh, I forgot to mention the most obvious "CV2 is unfinished" flaw: there are no enemies in Castlevania at the end, Dracula appears to just be a skeleton in a big black robe, and he's pathetically easy to beat, you just whip him a few times and he dies. Konami also did Gradius III with ends with the pathetically easy boss Bacterion who you just shoot in the mouth three or four times and he disintegrates.
At this point I kind of wish All Your Base Are Belong To Us had never existed, that one's played out for me something fierce.