Here's the story:
I decided to reformat so I could move from the Windows 7 Trial to Windows 7 Professional. I backed all my stuff up, then restarted to reformat.
For the record I did the USB method (thanks for the info, MO).
Here's what I was trying to do partition wise:
I have a big RAID +0 array that has 4 partitions.
The first partition: 40gb Windows XP 32 bit
2nd partition: 150gb Windows x64
3rd partition: 200gb Windows 7 Trial partition (and the one I used almost all the time)
4th partition: 800gb data partition with downloads and stuff on it (FULL BTW)
(the sizes are estimates, I don't remember the exact numbers)
So my plan was to delete the first three partitions and make it all one big partition for the new Windows 7 install since I never used the XP partitions anyway.
It read the USB Windows 7 just fine and got to the install screen where I chose the "Custom Install option". I was ableo to delete the three partitions in question. However, they didn't merge as I had hoped into one big "non formatted space". The first 40gb partition remained separate. Point being, no matter what I did it would not let me install the new Windows 7 on the 40gb partition or the new unformatted space. I tried formatting the unformatted space and just about everything I could try to do. However, nothing I tried worked.
So, I decided to just cancel the Windows install, go back into my Windows 7 Trial install that I've been using, and then see if I could work some magic with Partition Magic or something similar.
When I restarted I got the dreaded "NTLDR is missing, press Ctrl-Alt-Delete to restart".
After messing with the boot order and what not that message kept appearing. So I then tossed in the Windows 7 Boot disk I made for just this reason (the disk you can make that gives you system repair/recovery options etc).
I booted off the disk and chose system repair. When it finished I checked the log and it said something to the effect that it fixed the fact that there was either no system partition or something about the system partition was missing...or something lol.
I rebooted and got the same error.
I rebooted off the disk again, retried the System repair, got the same log message, then restarted.
...and all hell broke loose.

I restarted and the system never gave me the familiar "beep" I hear before it goes into POST. Nothing ever came up on my monitor. My video card fan never went from "super high start up speed" to the medium speed it spins down to once the PC goes into POST.
It just sits there with fans spinning...doing nothing that I can see.
And that's how it remains.
What I've tried so far:
1. Messing with the RAM, taking 1 stick out at a time, changing slots, etc
2. Clearing the CMOS repeatedly
3. Moving the video card to another PCI Express slot
4. Different monitor
5. Different video card
None of the above has worked.
The 2 digit code on my motherboard is giving me "FF" for fully functional.
All the fans I can see are spinning.
Yet, the PC apparently can't even get to POST all of a sudden and I have no idea why.
I guess later I will start by taking it all apart, unplugging everything except the bare essentials and start from there.
However, any help/suggestions/etc are most definitely appreciated.
If you need a newfound respect for your PC, get stuck using a 5 year old Dell Inspiron 1100 laptop for awhile. Blech.