Just swapped from a 518 4 spd overdrive auto to a NV3500 5 spd in my 87 Ram.
Hard to say drag times because they dates were separated by 2 years but I gained 3mph with the manual.
The biggest place I can note a difference is a hill I climb everyday on the way to work.
With the auto I had to switch (manually in my application) from OD and Lock Out to Drive to climb this hill. I could do it in 4rth but it took about half throttle.
With the manual the same hill can easily be dealt with by only adding 1/8" more throttle to climb the hill.
Mileage seems about the same and I'm not sure why. The only thing I can blame is the chrome Hurst shifter sticking out of my floor.