Chrono Trigger and FFVI obviously have great sidequests as already mentioned.

Quote Originally Posted by Futan View Post
My favorite was probably the one where you get drunk with someone at one of the bars and blackout. When you wake up you need to go back and fix all the trout you did. lol.
Easily one of the coolest quests in the game.