Apart from being a GL-4 lubricant, redline MTL IS also designed to be used in transmissions that call for ATF. Before I rebuilt my 89's tranny with the newer fiber lined blocking rings I found that MTL worked better than D4. After the rebuild D4 wasn't so hot. Now using Royal Purple MAX ATF. Working pretty darn good.
Just wanted to set the record straight about redline MTL. There is no good reason not to try it in a SHO tranny. If it works, keep it. If not, try something else. I'll mention that I used to own a 90 and later a 91 4-cyl 5-speed toyota camry and toyota called for ATF in the tranny. IIRC, a dexron II atf. I switched both of those to Redline MTL and the shifting was perfect. It was notchy with the factory fill but absolutely perfect with MTL. Way better than the SHO tranny ever could be. Butter.
Really, it comes down to trying a fluid which is appropriate to use in the SHO tranny (MTL is on that list) and finding out which one works best with yours. In the old 89 tranny before the rebuild (between 140,000-200,000 miles) with the old brass blockers MTL was ok, D4 was terrible, and a mix of 50% D4, 40% MTL, and 10% MT-90 was butter. In the rebuilt tranny with fiber lined blockers Ford Motorcraft brand Mercon was pretty good, D4 was terrible, and Royal Purple Max ATF is pretty good to very good...can't remember if Mercon was better or if the royal purpple max atf is. Still have a bit of extra effort to get into first but nothing like straight D4. Before the Royal Purple I was going to try 70% D4 and 30% MT-90 and I might try that in the future...the royal purple is fairly close but not quite "IT" for my 89's tranny. The Royal Purple is good enough though that I'd ditch that mix in 300 miles if it offered no improvement. Lol, and I still have yet to try Royal Purple SyncroMAX and even mixtures of Syncromax and MAX ATF. If I find anything that works as buttery smooth in my rebuilt 89 tranny as MTL did in my old Toyota Camrys' then I will stop and stick with it forever.