Planescape: Torment is one of my favorite games and the gameplay is absolutely terrible!
Good example of a great RPG with terrible combat system was Arcanum but even there the gameplay was great (except the combat).
I hate modern narrative-heavy games deciding to remove the gameplay to focus on the story/atmosphere. Movies/books are much better mediums for this kind of entertainment.