Adding an expensive turbocharger and increasing the intake air pressure might not be a smart thing to do. GM's L81 3.0 Liter V6 hasn't proven to be the best engine they've ever made. Among other things, its timing belt system is prone to failure and has been the subject of a major recall. The internal oil cooler/heat exchanger can leak causing oil and coolant to mix, cross-polluting both systems, and causing major damage if gone unnoticed. Plus, the transmission and differential might not be up to the added HP strain. That said, the L81 2.5 Liter was used in the SAAB 9-5 Turbo. According to Wikipedia it produces less HP than the 3.0 Liter, but more torque. To me it's not worth the time, energy, or expense to warrant a swap. The L81 in the SAAB is configured for a front driver so it's positioned transversely. You'll need parts off the 3.0 to make it fit in a Catera.
There is an alternate supercharger kit I found while googling but it sounds a little like snake-oil to me. At best I think it would perform like a Ram-Air system but I guess it's better than nothing. A Google search for: Electric Supercharger turns up quite a few products.
http://www.mimousa.com/info/blowerinfo.asp http://www.electricsupercharger.com/eram2.php http://www.turbomagazine.com/tech/04..._supercharger/
None of these should put a strain on the engine other than on the battery charging system, and there is no mechanical drag as with a conventional supercharger. Off boost they freewheel like a turbocharger. I'm not in any way recommending these products. I just thought those looking for gains via K&N intakes, or removing exhaust resonators, might be interested. Those are passive devices that only allow the engine to inhale and exhale easier. A fan in the intake path is an active device that pushes more air than the engine will normally draw. If you honestly believe that an air filter will give you 20 HP extra then one of these blowers should be good for 50 or more. (Sorry for the sarcasm. Couldn't resist.)
GM revised the L81 3.0 Liter engine for use in the Cadillac CTS where its displacement was increased to 3.2 Liters (LA3). They don't appear to suffer from the same problems as the L81. It will fit in the Catera seeing as the engines are the same externally. The swap has been performed successfully a few times I know of by owners who suffered catastrophic cambelt failures. The LA3 will give you 220 HP with the CTS ECM versus the L81's 200. If you have a ruined L81 this might be worth a trip to the recycler.
The way to go if you want really serious power and reliability, and if you have deep pockets, would be to swap the L81 for an LS1 5.7 Liter V8. It is rumored to fit though I haven't read about one here. The late great Pontiac GTO (Holden Monaro) might be a source for parts like the LS1 V8 itself, transmission, ECM, wiring harness, driveshaft, and differential. Some GTO measurements taken at a friendly auto-recycler will answer a lot of fitment questions. Holden in Australia has been putting LS1s in their Commodores for years so the other necessary bits are available. Just find yourself a helpful Aussie parts counterman.