It *appears* that my hardware issues were due to my hard drive crapping out on me. So the bad news is that I had to get a new drive and have been installing Windows XP for the last several hours. The good news is that I went ahead and upgraded to a 10,000 RPM drive so at least something positive came out of it.
Like I said it appears that the drive was my issue. It had to either be that, my power supply or my MB. I kept getting those blue screens of death and couldn't narrow down what might be causing them more than that. WIth this new drive though I've been downloading and installing programs for several hours with no blue screens so it looks like I guessed right.
I've set Steam to DLing COD4 overnight and I'll have to grab TF2, HL2 and the rest of it tomorrow.
I won't feel completely out of the woods until I get to gaming and see if everything is working properly with video and sound.