Loaded dice are fine, as long as there is an option to turn them off.

Larian probably does need to fine tune the failure modes so that they lead to more interesting results, AND so that they acknowledge skill on a missed roll. In other words, a player with Arcane knowledge who misses the roll will get a somewhat more informative answer than a player without who misses.

Adding skill ranks does nothing to solve the problem, because you will still have a chance to miss the roll if RNG works poorly for you that day.