No.
There are many different reasons why I don't see a big boost for computer hardware coinciding with the release of DooM3. First off is the larger computer market. This year, ~100Million PCs will be sold(on the conservative end) while the most popular PC game in history has hit roughly twelve million over the course of its life(The Sims). The amount of units DooM3 is likely to sell will be well below that of the highes selling titles, it will likely be in the couple million sold range by the end of the year, although I could see it possibly pushing up as high as four million at the outside(although I can see it being in the ~1million range also). Compare the likely amount of gamers who will buy D3 versus the computer hardware market at large and they represent a very small percentage, at the absolute highest end you are talking about 5% of the market if the game does extremely well and every single gamer who purchases it upgrades their rig(which obviously won't happen).
Now spurring on overclocking I think will happen, but not because of a large portion of D3 players charging in. No, I think if 3% of DooM3 gamers take up OCing that should result in a minimum of 30,000(though that could be as high as 150K if the 3% were true) new OCers brought in to the community. To the hardcore OCers out there, a spike of that level is easily noticeable but can give the impression that this is a mass market issue when it is in fact a relatively minor bump.
I think DooM3 may encourage some 'dormant' overclockers to pick the habit up again, but the market isn't really the same as it once was. Looking back it wasn't unheard of to get a ~30%-50% OC using typical components on certain devices every once in a while. Some of the old 486 level chips(from the DooM1 era) and the Celery 300@450 springs quickly to mind. When you were moving from 30FPS-45FPS that was something worth noting, 20FPS-30FPS was even moreso. Today's CPUs, even those that are extremely overclockable, tend to hit 30% increase at best. That in itself would likely still be worth doing, but with DooM3 the bottleneck is going to be the vid card for anyone thinking about upping the details. On that front, the typical vid card overclock is in the 20% range or less. Moving from 30FPS-36FPS doesn't make a staggering difference. The parts aren't around that support the kind of overclocking that we saw in years past for the most part. Sure, there are some exceptions like some of the XP2100 chips, or some of the R300 core boards, but even those don't come close to the ~50% boost that we could get in years past(at least, ruling out exotic solutions).
DooM3 is going to be limited by shader op speed and stencil throughput on pretty much everyone's rig(when things are turned up of course). Upgrading to a R3x0 or NV3x core is going to land you the biggest performance boost, OCing the NV2X core would likely be next followed by a R3x0 OC. Considering that vid card OCing is fairly hit or miss(although a slight improvement can be had with improved cooling), I don't expect anything like what Kyle is talking about in that article(yes, I have read it). Sure, the OC community is likely to see a sizeable spike from dormant/new OCers, but not in comparison to the big picture.
Another aspect is Kyle's misunderstanding of what people will tollerate in terms of framerate. Goldeneye sold ~10Million units(still the best selling FPS ever) and ran in the mid 20s. Right now UnrealII is doing OK with the same type of framerate issues people are expecting from DooM3. 20-40FPS is considered playable by the overwhelming majority of people. Obviously it is horrendous for fast paced multi-player shooters, but for a plodding single player hybrid survival horror/shooter lows in the 20s and highs in the 40s is far from a major pain. Obviously higher framerates are better, but it won't be necessary for the gaming experience.
One tangent that DooM3 will reignite are the 'real game' bench lovers(those who can't stand 3DMark, but are still fond of benches). They are decent in numbers, and Carmack's engines always being them out of the wood work 😉
