I recently bought Dragon Age: Origins - and I've got to say, the story is fantastic
It's very well crafted, with excellent voice acting and well played out cut-scenes... but the game is leaving me totally flat. The graphics are solid, the music is great... everything is there - but the actual gameplay just doesn't do it for me.
I guess in this case, for me it's a matter of the story getting in the way of a potentially great game.
Strange, but I compare it to something like Oblivion - and it just pales in comparison (I know of many who will be squirming in their seats just reading that). Oblivion had a solid (epic) story, but let you approach it at your own pace. More than half the fun was buggering off on some random quest tangent, or just running around exploring. It was (for me) the perfect example of the story never getting in the way of a great game.
But it's not the strength of the story, nor the quality of the "game" - but how it's all done. If it's done well, it doesn't really matter where it's strengths lie.