I never play games because of the story. If i want a good story i will go for books. If the gameplay and the atmosphere is fine, the game is fine (for me)
Planescape: Torment is probably the best example I can think of, but there's many others.
Now that I have a new macbook though, I might pick it up.