I've never understood the appeal of the Metroid Games - what am I missing?

You are missing a lot! IMO its the best sci-fi platformer.

I had great fun playing this series, some amazing boss battles, unlock new weapons and abilities gaining you access to new areas of the game