I think part of the reason missing isn't fun is because that 75% chance can mean missing three or four times in a row, and then when you do finally hit, it rolls 1-2HP damage. Er... yay.
But to your original point, that does sound like a much more interesting way of playing against goblins. It's similar to games I've modded previously where I've substantially decreased enemy HP to stop them being bullet-sponges and significantly increased weapon damage and chance-to-hit, making fights much more dynamic (and also way more dangerous for me as well as whoever I'm fighting). My main not-fun things are the combination of a complete miss, even with a high chance to hit, frequently low damage and long, drawn-out fights. But some of that irritation may be due generally not being a fan of chance-based games which is what D&D is about AFAIK, so I feel my objections may be a little... well, off-target, which seems to be very much my current thing. D:
I think this is a great example of what BG 3 can be if it more closely follows the rules of 5e.
Let's say you have a plain Fighter, that just swings a sword. Against some enemies, ones with low AC like Zombies, they are going to do great! They'll hit, and do quite a bit of damage, and most importantly, will use up almost no resources because it doesn't eat up a spell slot to cast "Sword to face". You'll also never being doing 1-2 damage because of your attack ability modifier presumably being +2/+3, then another +1 or +2 minimum from the weapon damage die.
But what happens when you come up against a high AC target and your Fighter starts missing a lot? You get frustrated right? This is where the beauty of D&D (and 5e) come to help. Maybe instead of just swinging your sword, your Fighter wants to knock the target to the ground? They make a Shove check with one of their attacks, and now suddenly you have a prone target (if the Fighter wins). Huzzah, now you have Advantage!
Even better, it makes the player realize that they have an entire party at their disposal (6 party size please)! So yeah, maybe this fight your Fighter doesn't do much besides soak damage and be a 'sticky' target. Maybe the big armored enemy is bombarded by spells that target their weak stat, like Dex saves or Wisdom saves? Perhaps this is when you throw down that Sleep spell to knock out all the small enemies to everyone can gang up on the BBEG? Or the Cleric tosses everyone a Bless, and the Monk stuns the target, etc.
There are so many solutions to "I keep missing the target when I swing my sword" in D&D you couldn't possibly list them all. Please, use those solutions. Make players realize how much is out there. Force them to grow beyond just swinging their sword.
Or, just have them turn the difficulty down. Make enemy AC and Player stats change with difficulty level. But have that 'true' difficulty setting when players want to realize that the solution to problems in 5e is to use the tools made available to you in the rules.
