Looks like you missed the classics, huh?
Chrono Trigger (RPG) - One of the best games ever and I bet you already played it cause everybody has xD. Great time-travelling storyline and the characters are all lovable. If you did not play, it's exactly what you want.
Hotel Dusk (Point clik novel)...