I had constant bsod's in this game whenver I played it fullscreen and they were driving me nuts. Found out that it was a fuck up in old NForce BIOS's (I have an A7N8X with newest BIOS) that affected several other games too, and I fixed the issue by underclocking my processor.
Realized it wasn't Fallout 3's fault when L4D started having the same issues for me, but a lot of older games worked fine.
After I did the underclock both games runs perfectly, so yeah. Don't necessarily blame the game. Might be some weird hardware issue.