What exactly do you mean ?
I absolutely ABHOR level scaling. The very idea is a conceptual stupidity which only exists due to the lazyness of designers. Any kind of level scaling is already anathema to me. Also, it comes usually in hand with randomly-generated items, which makes everything the same (you can find, early in the game, "athenian helmets" from the current war in the old lost Ithacus ruins that are explicitely said to have been abandonned for centuries, kinda kills the vibe).
While AC:Origins had zones with select levels (which is already kinda stupid, but at least it's fixed), Odyssey has zones with only "floor levels" (i.e. : the enemies are at least this level) and every single foe that is above said "floor level" is scaled to the player.
As for the stat inflation, it's just the usual (but grossly ridiculous) pileup of meaningless zero - you'll do 100 damage at the beginning, 100 000 at the end, but the fights will still be about as long as before. The numbers are basically meaningless except to make you grind.
I just started this game, notice there are 4 settings for scaling - standaard, heavy, medium and light,
which one would you recommend ?
That's up to you and how much you want to be able to outpace the lower-level foes - all the scaling options only affect how much levels more you can have compared to a weaker foe, by steps of 2 (so between 0 and 8 or so, IIRC).
So basically, if you are in some early zone with a floor level of 10, as long as you're below lvl 10, all foes will be at minimum lvl 10. If you are lvl 33 and you have "light scaling", they will be at minimum lvl 25.