!!!Update: I swapped my old 8800GT and it's still making the same noise, but just not as loud. I just loaded up AC and it is making the exact same noise it was doing with the other card! So it looks like it's not the card (which is what I was suspecting). I have to get to bed but I have an extra power supply that I'm going to swap out and see what happens then. So for sure it looks like the power supply or mobo?
On a side note, whenever I try to use the front USB port on the case, it causes the computer to restart as soon as the metal USB connection makes contact. Not sure if that is somehow related or is another issue entirely.
Edit: Jezza, I feel stupid. I'm pretty tired and as a result forgot to plug in the connector to the video card. I didn't see it. I edited it out.
-----signature-----
If you dont like the police, the next time you need help, call a crackhead.