the modernized combat in the SH2 remake is funny to me because i've been playing morrowind lately, with a lot of mods but without any mods to change the combat at all - you can still fail to cast spells, you can still miss attacks. and it makes it apparent what the game was going for, and what i feel like the combat in the modern titles like oblivion and skyrim misses by attempting to "modernize" it.
the game was never an action combat game. it's a traditional PC RPG, a sequel to daggerfall and arena, and it owes more to wizardry than it does to ocarina of time. if you're thinking of it in terms of a fast paced modern action RPG, like oblivion and skyrim prime you to think of it as, you're viewing it through an unfair lens. it's more like a hack and slash where you click on enemies over and over until they die. it's dungeon siege in first person.
and if you think of the combat that way, it makes sense! the excitement isn't in using your epic gamer skills to dodge out of the way of attacks and execute combos, to Get Good. the excitement in morrowind is "does my character build have the skills, equipment, and items to defeat this enemy before they defeat me?"
the dice rolls, the chances of just missing an attack or failing to cast a spell, are part of that design. the element of luck adds tension in the same way dice rolls do in XCOM and other turn based games, and complexity in that you need to be paying attention to the results of the dice rolls and their effect on your resources and stats compared to your opponent. and if that's not fun to you, that's fine. i don't want to act like, oh, well, that obviously makes it superior, because it doesn't. but i also think it's not inherently worse. it's different, and interesting,