a couple of things here.......
All Omega A and Omega B manual gearboxes are Getrag 240, made in a GM-specific casing and with either shot-peened gears or not, according to the usage.
A Getrag 240 without shot-peened gears is called "R25"
A Getrag 240 with shot-peened gears is called "R28"
The bell-housing for these is integral with the gearbox casing and comes in three shapes - 4-cylinder petrol & diesel / V6, 6-cylinder diesel and "cam-in-head"
Other than that, there was a Getrag 265 used in some Senator A and Monzas, which uses a separate bellhousing. Beware, though, this bellhousing is "cam-in-head" bolt pattern and won't fit any Omega B engine.
There are three other strong GM boxes :-
ZF 6-speed. Used in Lotus Carlton - fits "cam-in-head" engines
Tremec T56 used in Commodore and Monaro - fits V8 only
Borg-Warner T5. Never used in any V-car
If you're contemplating more power, you don't automatically need a stronger gearbox. There is a natural limit for how much torque you can put through a 'box - and that's when the wheels spin. The "worst-case" for any gearbox is going to be re-starting a car with a heavy trailer on a hill.
hope this helps.