Best pick: Final Fantasy X
Literally my favorite game solely because of the storyline. From start to finish, I can't tell you how many times it broke me down emotionally and left me for dead. Like damn dude fuck me up. Consecutive playthroughs dont make it any easier to handle. Always find myself shedding tears throughout the story, but maybe I'm just a pussy. All the characters are memorable and have good back stories and you find out earth shattering information at key points that hint at the story as a whole and its just fucking hot. Like 10/10 game with a hot story.
Don't really have a worst pick. If I feel a game is gonna have a shit story, I generally won't play it.