OK, THANKS!! for the reply gents, it is appreciated. Granted, it is only a hand few of you who replied, but it was definitely all I needed really to see that there are a few DIY here on site.

I have decided to go ahead and pull the trigger on the service/main manuals. I know they are as big as telephone books, stacked 5+ inches thick, but hey, thats good, means all info will be in them. Are part numbers included in them? When I get the books I'll report on what I think of them. Yes, I also been told by my service adviser, that in some cases you need "special tools" to do the job correctly, also advisable so nothing is broken in any process you attempt.
Status of my H2: Took it into the shop last Wednesday. Currently at my Hummer dealer to repair the above problems. Diagnosis: Oil leak: "The oil is leaking from the front right axle yoke area, tech also recommends that you replace the U-joint with it, just in case the old one falls apart later on, don't want to take it apart again just for the U". Currently? Waiting on a yoke, none available, had to order one. Apparently our yokes have a seal also, initially the oil leaked on my driveway, then stopped, (only so much oil could leak, donno how much was left in the case) but it was not totally dry, then oil from the yoke area was spraying all over down there when driving getting it on some hot exhaust pipes, thereby my "oil burning smell". Costs for repairs? Yoke=$220.62, U-joint $95.00 + Labor $420.00.
Windshield wipers won't shut off when raining: Update, when I took it in, the washer sprayer stopped functioning also, tech said, "pump is not getting power". Power comes from? You guessed it. Bottom line: Our hummers use a 2-part assembly for our wipers. The motor and a module (I'll assume they mean some type of control module). The washer gets its power from the motor, thereby all the failures are pointing to the motor. (logically, makes sense to me). Even tho the motor is a 2-part assembly, you have to replace them together, (again makes sense to me, what if you replace one and not the other and the problem returns?). Not sure, I'm still a little confused on the "can you just replace the motor only"? No matter, in my case they are doing both, I think it's all one assembly anyways, I'll find out when I talk to my adviser tomorrow again to check on status. Costs: motor & module $248.02 (I think he's made a mistake on that price) I'm sure they'll correct it, labor $360.00.
Finally on the door locking issues. Don't cha know it, and ain't it always this way, they worked when I wanted to show him. Would not fail.. Inter-mitten problem, ain't it a biacth.. So thats not even gonna be looked at, heck if I have to I can manually close the rear doors, hmmm, I'm gonna have to find out if there is a manual way to close the rear hatch however..hmm otherwise THAT will be a problem.. Thats it guys a blow by blow picture, I'll let ya ll know when I get my baby back if she's "feeling better"...

I know one thing, my wallet is gonna feel a little lighter..