Cut my teeth on Dragon Warrior for the NES, but looking back it's just kind of there. One I that do have a big soft spot for is Phantasy Star 2. It had a creative ending IMO and also had a tear jerking mid game death before FFVII made it a thing.
Suikoden was another good one. Haven't played any of the sequels though. Great sprite work, interesting characters, awesome music, and simple but compelling story.
It may be uncool to say, but I also really enjoyed FFVII and FFX. The plots make about much sense as a broken penny, but I still feel like they did a great job of bringing you into the world and feeling for the characters. Unlike a lot of people I loved the FFVII remake too - including some of its plot changes. They way over used Sephiroth and it veered a bit too much into anime trope territory for my taste, but I'm really on board to see where the story is going from here. Probably helps that I never played through Kingdom Hearts, so "getting Nomura'd" isn't a thing for me.
DC