The Metroid Prime series is very good as well. I liked the first one a lot more than MP2 though. I've never gotten around to finishing MP3 for some reason, and it remains the only Metroid title I haven't completed. Last year's Metroid: Other M was sort of a throwback to Super Metroid in play style, but wasn't nearly as memorable to me as SM.
I used to be a big fan of the Castlevania games as well, but that series really went downhill in terms of quality in recent years.