Oh yeah, I like these games too. They got me into Metroidvania-style games (for example, the 2D Castlevanias made after Symphony Of The Night, or Simon's Quest, or Shantae and the Pirate's Curse, or that Bloodstained thing on Kickstarter).
Well, I don't like all of them. I got Metroid 2 as a kid (on the old Game Boy, the gray brick), and I just got lost and confused while playing it. It was kind of annoying, I didn't like it.
All the other ones I've played were great, though. I loved Prime, even though I never finished it. It was just so much fun, and it made exploring feel good. Prime 2 was also good, but when I was younger I never finished it because Bloggs scared me. Never played Prime 3, which is a shame, I heard it was great.
I've played Fusion and liked it, it was my first Metroid after 2 and really good for getting into the series (though not particularly indicative of how it generally works, admittedly). Zero Mission was also great, especially the Zero Suit section, was not expecting that after beating Mother Brain, and it was weirdly enjoyable (though not as enjoyable as going back and punching out Space Pirates with the fully-powered Gravity Suit, that was so rewarding).
I've gotten through most of Super Metroid as well, and greatly enjoyed it (though Maridia confused me for a bit), but I got stuck on those gold divekicking pirates in Ridley. How do you deal with those?
Also, you should totally get Super Metroid if you like Metroidvanias, it pretty much set the standard for the Metroid series (I'd argue Prime is better just off my gut, but can't back that up since it's been so long since I played Prime). Just remember that you have a Run button in this game: it's something that's never happened before or since in Metroid, so it's easy to forget, but you need it to progress.