In general you do get a small MPG increase, it's more noticable in cold weather.
FWIW when I changed out the factory fill trans and diff fluid on my BMW 325i, 1989 model, to Redline MTL and 75-90 gear oil, I didn't see more than a few tenths of a MPG improvement.
But in the Las Vegas heat, the...