-Is it an overhead cam or pushrod motor?
Pushrod.
-Why the hell did gm stuff it under the damn firewall?
The V8 is a much larger engine, and they didn't want to move the transmission for the V6 version.
-is there a way to get the heads off without pulling the motor?
dunno.
-Will an upgrade in the ignition system, exhaust, intake, and other areas of N/A performance be noticable?
The GM ignition system in most cars is up to what ever your doing (should be no different on your ride). Exhaust and Intake will increase your performance noticeably, but not too 300hp.
-Is there a decent selection of performance parts for this engine?
There are LOTS of parts for that engine because of it's popularity in the Grand Prix market.
-does the 4L60E auto tranny have any balls?
www.gmpowertrain.com states the 4L60 is used to this day on a wide variate of engines including the 295hp 5.3L Silverado.
-Are there any bolt-up supercharger kits for it that aren't a big pain in the ass?
I've seen people put the Grand Prix GTP intake/supercharger setup on the L36 block. I've also seen people swap in a L67. Check
http://forums.motorswap.org/
There is an aftermarket Supercharger for the L36 Grand Prix, dunno how hard it would be to make it bolt to a F-body L36.
-Is it worth it?
The F-body platform is capable of handling LOTS of power (far more than 300). This basically depends on what your looking for. Power in a strait line? Canyon carver? Daily driver with pep?
What do you want your car to do?