the best progression system might be one where the protagonist can make permanent mistakes
i like systems where every choice isn’t reversible
choose the wrong technique and you have to live with it. specialize too early and another path becomes impossible. build your body around one type of power and later discover that another route would have been much better.
that makes progression feel like an actual journey instead of a skill tree where you can eventually collect everything.
it also makes early decisions matter again
if the protagonist can always respec into the optimal build later, a lot of the tension disappears.