If you are really stuck on this idea.. I would recommend a Quaife Universal gearbox..And if you are pretty handy and can fab your own bell housing. I used to run autocross and most of the Legend class guys I see swear by their gearbox's. They have Race and Road applications.. If you have the budget for this modification that would be the way to go.. Because the cheapest I found new has been no less than 5k and some of their offroad ATB trannies go for at least 11k. Also when messing with the gearbox on these vehicles you may need a configurable ECU/PCM. Because the amount of fuel dumped depends on what RPM's you are at revving out with little fuel can be a problem..This already doesn't look cheap.. IMO Your better off doing a motor swap on the TB..At least with something fully tunable...
I don't think it needs to go that far... I don't feel like looking right now, but the guy who is putting a 4200 into a Supra (on this site) said the only thing he really had issue with was the flywheel, and its bolt pattern... This engine mates up to a standard 4L60E, so I would guess that it would mate to a Tremec 6-speed out of an F-body, or a 5-speed out of a truck.
You'd just have to turn off the part of the ECM that looks at the transmission, and make it so it doesn't throw a code... The fuel would be fine, other than trying to do TQ management with the DBW throttle, when it's not needed... Definately need a programmer, and maybe have to adapt a PCM from something else...
Mike