Strangely, I'm the opposite: Dragon Age II had the least fun gameplay for me out of the series, yet the story is probably the best, tightly compacted one there is.

Other games where the plot is great but the gameplay is only 'good enough' include the First Mass Effect game. Story was fantastic, but the gameplay was only not excellent. It had good moments, though.