Guide worked perfectly. Wish I would have had some canned air on hand to clean out the innards. Other than that it was great. Only thing I messed up was not getting the front bezel back on perfectly. I had a little foam pushed down over the access door after getting the bezel on making it impossible to get the access door back on. So I just left it off for now. When I am feeling a little more ambitious I may take all those screws off to fix this.
After installing I just put in my original Snow Leopard install CD and rebooted. Had to go to disk utilities and reformat the new drive and then everything installed just fine. I will upgrade to Mountain Lion after Snow Leopard. I opted for this route because I had the Snow Leopard CD handy and just wanted to make sure the hard drive install was proper.
The hard drive I installed was a Seagate 2TB 7200 RPM that I picked up from Crucial for $110. Old hard drive was completely dead.