Final Fantasy 2 seems to come to mind with it's incredibly cheesy, static storyline. I liked the weapons/magic levels, but the dodgy storyline and "ask" system can go straight to hell.
(I'm talking about the Japanese FF2, not the FF2 on the SNES which was FF4)