I also forgot to mention, although my PC seems to be able run the game on reletively high settings smoothly, to avoid the BSOD I have to drop the settings down to the medium range.
It took me a while and many freeze ups tweaking the settings to find the best quality without the PC freezing up.
I just wish more people were having this problem then it might force BIS into looking at it. As it is, I don't think they really give a shit. I have seen NOTHING from them regarding this problem, they have not even acknoledged that it is an issue.
Play around with your graphics settiings in game and follow that method I posted above and see if you can come up with some decent results. Like I said, I spent quite a lot of time getting this piece of shit to work ;-)