Probably a slightly dumb question but where exactly should you mount a Red Dot?

Yes I know it goes on top of the pistol with the front towards the pointy end

I mean is there any difference from all the way forward/back or mid rail?? Since (I assume) eye relief isn't an issue is it just aesthetics or is there a rule of thumb as to position.