What’s the best alternative then in your opinion? I kinda like that there’s a bit of gambling but I agree that it could be less.

If a barbarian rolls better than a wizard does dnd make it so the knowledge you gain is less if you roll with a less knowledgeable class? I feel like that could mitigate that issue.