So you want a realistic-looking projectile system ?
Which the tip of the projectile will obey the rules of Projectile Motion ?
Well, if you are comparing to Rexxar's ultimate, Primal Roar, it uses a static dummy unit, therefore it can be achieved by just editing this;
Art - Maximum Pitch Angle (degrees): -90 (face down) / -270 (face up)
That's how Rexxar achieve the effect.