Normally I'd rec a bunch of obscure stuff, but since you say you have limited exposure, here's a bunch of games from different genres, most of which are widely agreed on. If you know which of these you like and dislike, that'll make a good jumping off point for more specific recommendations.
NES: Fire 'N Ice, The Adventures Of Lolo 3, Megaman 2
SNES: Kirby Superstar, Chrono Trigger, Super Metroid, Yoshi's Island
Gameboy: Link's Awakening DX
Gameboy Advance: Advance Wars, Fire Emblem
I’m interested in the FF series but have no idea where to start either 🤷♂️
Final Fantasy 6 for the SNES. It was localized as Final Fantasy 3, so if you see that on the SNES, that's also the right one.
They're all fully separate but 6 and 7 are widely considered the peak, and 6 is shorter.
If you play that and think "I want an intentionally dumber plot and smarter RPG mechanics" then play 5.