Mine has to be Dragon Quest: Rocket Slime, a DS spin off of the Dragon Quest series that sees you playing as a slime operating a tank and rescuing the people from your town. You run around the overworld, collecting items to use as ammunition and saving money to upgrade your tank. The art and music are just as great as you’d expect from the Dragon Quest series. It made fantastic use of the DS’s dual screens. It’s also written for a younger audience, so a lot of it is just really silly and fun! Try it out for sure, I’m so sad there’s no sequel :(
For me it’s gotta be Secret of Evermore for the SNES. Kinda old game but I absolutely loved the gameplay and story when I first played it as a kid. Have been replaying the game many times and it’s always a great experience.
That game made me so angry with the puzzle in the second world where you have to switch control to the dog in order to jump the bridge. I never really forgave it. I also found a bug where I was able to pick up infinite beads which kind of trivialized the game.