At the same time, it’s by far the most important battle in the context of their stories, so it’s no wonder it’s the most effective. It’s the only SW movie where a space battle is the only climax, and where the main character is. Qui-Gon is the main character of TPM and he’s not in the space battle. The space battle in AOTC is not the climax. The space battle in ROTS is not the climax. The Battle of Hoth is not the climax of TESB. Luke is not in the space battle of ROTJ. Rey and Finn aren’t in the space battle in TFA. The space battle is not the climax of TLJ. And, finally, Rey isn’t in the space battle in TROS. So the Battle of Yavin is unique in that regard.
But it’s also the best for other reasons you mentioned above. I’m just saying, none of the others were designed to be this impactful.