I think a major problem here is something which I friend of mine recently identified. Back in the 'good old days', all you needed to know about a computer was: (a) its processor speed, (b) its RAM and (c) its harddrive capacity. If a game met these 3 requirements, then you were 99.99999% certain of being able to run it (even minimum-though only just).
Today, things are waaaay more complex-ever since computers went beyond the 1GHz threshold, I have noticed a huge variety in performance and compatibilities between the different brands of machines (Athalon, AMD, Celeron, Pentium etc). Add to this the various video and sound cards-and the way they interact with the CPU and other hardware-and suddenly minimum and Recommended requirements start to mean precious little. As a case in point, I originally purchased a Radeon 9550 video card (256MB RAM) and found Civ4 to have fairly frequent CTD's and graphics artifacts. I also had huge problems, though, with things like Google Earth and Doom3 (heck, doom3 wouldn't play AT ALL-PERIOD). Then I actually downgraded my video card to a 9250 (128MB RAM) and, guess what? The game runs like a DREAM (as does Doom3 and Google Earth). My point is that, before you rush to blame the game, consider this-if it was simply a software problem, wouldn't everyone be unable to play the game? Isn't it possible that hardware incompatabilities which already existed-but may not have been visable with other games-have simply been brought to light with this particular game? It is simply too hard to tell, these days, exactly where the blame resides when a game goes wrong (I mean, maybe my problems weren't ATI's fault-perhaps Celeron processors, at that end of the spectrum, and ATI chipsets just don't go together!) What I do know is that, based on all the interviews I have seen from Firaxians, they are shocked, alarmed and-truth be told-confused by the number of 'technical' problems people are suffering from-largely because they themselves tested the games on a wide array of different computers, and never had these problems. They have also said that they ARE working tirelessly to fix these problems-which may also be why we are not hearing from them very much here.
I am personally sorry to hear of people having problems running the game-as it makes me feel guilty that I am having such a dream run, and enjoying what is-otherwise-the best game of the Civ franchise (IMO at least). All I can say to the OP is 'stick in there. I feel certain that Firaxis will fix these issues and, when they do, you will be very glad that you have the game!'
Yours,
Aussie_Lurker.