Isn't that simply because of the final half-step in major scale, and as such dependant on the scale/mode played? For example in mixolydian has full step in the

Isn't that simply because of the final half-step in major scale, and as such dependant on the scale/mode played? For example in mixolydian has full step in the end so it should not have such tension towards the octave