I mentioned in another post that Unreal Tournament 2004 was one of them for me.

Later on down the road, after I built my first gaming pc using an XFX 8800gts with a whopping 640mb vram - I tried to max out XCOM when it came out. Next thing I heard was a pop, then I smelled the smoke that was billowing out of my GPU. It was time to upgrade again!