The Legend of Zelda: A Link to the Past also has an excellent story. You play as Link, on a quest to rescue Princess Zelda and save the land of Hyrule from the evil Ganon. The game's world is filled with secrets, and the story unfolds as you explore dungeons and interact with various characters.
Another good one is 'Final Fantasy VI'. It has a very deep and emotional story. The world is on the brink of destruction, and the characters, each with their own backstories and motives, come together to try to save it. There are themes of love, sacrifice, and power, and the story unfolds in a way that keeps you hooked throughout the game.
Super Metroid has a great story. You play as Samus Aran, exploring a hostile planet filled with dangerous creatures. The story is told through the environment and the few interactions Samus has. It's a story of isolation and discovery as you gradually uncover the secrets of the planet and the Metroids.
The 'Final Fantasy' series on SNES, like 'Final Fantasy VI'. It has a complex and engaging story. There are multiple characters, each with their own backstories and motives. The plot deals with themes of power, friendship, and the struggle against an evil empire. It's a story that keeps you hooked from start to finish with its epic battles and emotional moments.
Definitely 'Chrono Trigger'. The characters in it grow and change throughout their time - traveling adventures. For example, Crono starts as a simple young man but as he experiences different time periods and battles, he becomes more of a hero. Marle also develops as she discovers more about her true identity and her role in saving the world.
Chrono Trigger has an amazing story. It involves time travel and a group of diverse characters coming together to save the world across different eras.
The story in 'Secret of Mana' is also great. It's about a boy who finds a magic sword and embarks on a journey with his friends to defeat an ancient evil. The world - building and character relationships in the story are really engaging.
In 'Super Metroid', Samus Aran's story is remarkable. She's on a mission to stop the Space Pirates and the Metroid threat. The desolate and dangerous environments of Zebes, along with the backstory of Samus being an orphan raised by the Chozo, add depth to the story. As she battles her way through the planet, uncovering secrets and facing powerful bosses, it makes for an engaging SNES story.
I'd also recommend 'Super Mario RPG: Legend of the Seven Stars'. It combines the fun and familiar Mario characters with an interesting story. Mario teams up with new characters to save the world from a new threat. The gameplay is easy to pick up, and the story is light - hearted and enjoyable, perfect for those new to SNES games.
One popular snes visual novel game is 'Lunar: The Silver Star'. It has an engaging story with well - developed characters. The graphics for its time were quite good and added to the immersive experience of the visual novel aspect.