I'm not familiar with the 292 engine.... What bolt pattern (bellhousing) does it have?
I "think" it has a pattern similar to the FE (390 etc) engine. If so... maybe a C6 could be made to work.
If you want overdrive, there is an adapter bellhousing to use an AOD behind an FE. I'm not sure if this would fit the 292 without mods.
For manual shift trannys there are many 5 and 6 speed units that might be adaptable.... research needed...