Well, what would the effects be on games themselves, such as Stalker? I won't name mods (why Nightwatch edited my first post - my bad

), but I have noticed some oddities. It's a highly memory intensive game, and on various mods I've had problems with weather not changing. At all. At least three separate mods (okay, one did actually have an error, and it was fixed for the next version, but I digress). And certain things changing overtime - weapons not degrading any longer. Literally not degrading with use. When they did before. And then there's Civ III Complete which, after a while, kept locking up when loading, and it didn't even load the CD. That went back a year, in fact, and reinstalling seemed to fix it, but...it kept happening. Thought it was anti-virus scan related, but since it was exempted AFTER the memory stick was removed last week, I can't know for certain. But can faulty memory do that to games, you know, lock them up? Without the games being loaded, just at the .exe? How long can a memory stick be going before it actively manifests itself?
I've been told that faulty memory sticks are one of the biggest causes of hardware failure, and that is definitely right. The most extreme one, last week, was when the computer just turned off. In the middle of a game. Just turned off. Couldn't reboot because it keep BSODing after that. I'm no hardware guru though, so hence why I ask. Since as the only really intensive game I play is Stalker, I don't have much comparison on how it might affect games/software. I'm assuming it would have an effect. Firefox seemed to lock up last week, though, before the problem was solved.
Again, basically wondering how the fault could manifest itself aside from all those BSODs. And what time-frame we are looking at here, how long it could take to finally go from minor errors to hardware failure. Just for future reference and curiosity, plus I am in need of knowledge. I get put off playing games because of errors like these...I get put off of a lot of things sometimes.