I guess the most obvious would be Earthbound, but I'll throw out a few more.

Lunar: The Silver Star and Eternal Blue on Sega CD or Playstation
RoboTrek on SNES
Final Fantasy: Mystic Quest SNES
Shadow Madness Playstation
Albert Odyssey Saturn
Paladin's Quest SNES
Okage: Shadow King PS2
Cosmic Fantasy 2 Turbo CD
Skies of Arcadia Dreamcast or GameCube
The World Ends With You on DS-maybe a little drama, but it's colorful and campy
Rurouni Kenshin Playstation
Tengai Makyou Ziria, Manji Maru, and Kabuki-Den for PC Engine CD
Tengai Makyou The Apocalypse IV for Saturn
Mother 3 GBA
Azure Dreams Playstation
Cross Edge PS3
Samurai Shodown RPG Playstation, Saturn, or Neo Geo CD

Hopefully that range of system variety might give you an idea or 2. Good luck, I prefer the light-hearted games as well!