The purpose of Torah study

Hello Rabbi Michael,
What do you think is the purpose that comes to a person who studies Torah? In the literature of thought we find several answers, adherence to the holy one, the bringing down of the Shekhinah to the world, the repair of the upper worlds, intellectual adherence that leads to providence, etc. These are just examples that I recognize in the thought of the first and last generations without too much in-depth acquaintance.
Or would you expect that person who studies Torah to improve his qualities and become a good and honest person (not necessarily that in practice that person would indeed be moral, but in any case this is what we would expect from someone who studies the Torah of the Holy One).
Another possibility is that one would not expect that a person who studies Torah would experience any changes other than that he now knows more Torah, just as a person who studies mathematics would not be expected to gain anything from this study, but rather to know more of the apparent truth.
In other words, should Torah study be treated as a specific occupation that has consequences, just as we would expect a person who engages in fitness and good eating to be a slim, strong, and healthy person, and if so, what consequences then pertain to Torah study? Or, like the last option I raised, is there nothing beyond Torah study other than the study itself?
I hope I phrased the question well, I would love to hear your feedback.