Most classic RPGs have lots of combat. What I don't see mentioned here so far is Neverwinter Nights. Especially the first expansion of the second game. Mask of the Betrayer. Lots of combat of course, but a story that your behaviour has an impact on. Search for a cookie cutter build, lower the difficulty. You can skip through the combat parts quickly that way, if you don't like them.
Also mentioning Planescape Torment again because it's weird and not so combat focused.
I don't care much as long as level scaling is gone. It's lazy and it signals that the world is built for and around you instead of you just being a part of that world.
When I'm walking around some well travelled road between cities I don't want to meet wolves first and then some damage sponge minotaur lord slaughtering every guard patrol coming through two weeks later, just because I levelled up a couple of times in between.