My system locked up completely same as you describe with the sound like a broken record and all.
The only way I could get back on was to recycle the power.
Though a few times all that happened was the sound getting stuck but I think that was more of an issue with my soundcard being fried...
I have 8800 GTSs in SLI and I had the same issue. As dmfg said check the temps. I found that my load temps started around 75-80 degrees C and after playing a bit they would move up to 85-90 and I would freeze up. I ended up water cooling the video cards, my load temps hit around 54-58 degrees...