Thought I would update my own thread in case someone searches for the same thing in the future. Ended up the wire to the camshaft position sensor had rubbed against the valve cover and shorted to ground. It had to be one of the following sensors; MAP, camshaft position, oil pressure , ac pressure , accelerator position , fuel tank pressure , or the wiring somewhere in between there and the PCM. I took a gamble buying it figuring that nothing would be an expensive repair. Just a potential for a lot of time and frustration trying to find it. Got really lucky that it was probably the easiest area to find and repair. I think the plastic wire loom is a terrible product. Not just on the H3, but just a junk product in general that should not be used in any automotive application. Any time I have to replace it, I use silicone vaccum line. It's heat resistant, abrasion resistant and will last the life of the car unlike the plastic garbage. I taped it all the way up on this repair just because what I had on hand was ugly orange. Also found 2 other bare wires in the process of tracking this down. On my first Hummer, I had a misfire caused by a fuel injector wire being rubbed bare under the intake. This one had the secondary air injection wires rubbed bare under the intake. I think as preventive measure you sould either find an AirDoc or add the silicone tubing around everything under the air intake. As another tip for tracking down similar wire issues, I would recommend looking for shiny spots on the metal where it's been rubbing. The spot on the wire was so small it was almost unseeable, however the shiny spot on the valve cover was much larger and more noticeable.
For posterity sake and anyone coming across this thread in the future, mine would only throw the code under hard acceleration. That led me to believe it was most likely the APP sensor or a bare wire that was being pushed against ground due to motor twist. Also, the sensors I listed apply only to 2008. The wiring on 2006 and 2007 are different. Not sure on 2009 and 2010, but I know for sure it's a different set of sensors on that 5V rail on earlier models.