Super Metroid is still the first that comes to mind. Amazing experience from start to finish.