Everyone and their dog has done retro reviews, and Yahtzee isn't a retro reviewer. He's said in the past that he's a critic, not a reviewer. All in all, it looks like mind soap for all the awful games he's had the displeasure of playing lately.
For this critique, yes, it was quite good. I laughed at a few parts of it. It's been a cornerstone of Castlevania to jump back two meters every time anything hits you. It's part of what the (S)NES titles so challenging.
Yahtzee: Don't do what anyone tells you! Just keep doing what you're doing, because I've enjoyed everything so far.