MW2 made my 80GB PS3 YLOD. Was I mad? Of course. But it wasn't MW2 that caused the YLOD. My PS3 had been overheating for weeks, MW2 just happened to be in there when it finally gave in. It could have been a PS2 game and the same thing would have happened.
Every time a new game comes out you see "*new game* causes YLOD!" and "*new game* causes RROD!". MW2 was the biggest game launch of all time, so you expect it to be in lots of peoples PS3s. Other games don't get this kind of attention, so its more common for MW2 to be in the disc slot.