Super Metroid is undoubtedly the single, greatest Metroid game ever created in the history of Nintendo. The Prime series as a whole matches it, but not one single game. Simply put, here is a list.
5. Metroid Fusion
4. Metroid Prime
3. Metroid Prime 2: Echoes
2. Metroid Prime 3: Corruption
1. Super Metroid