Red Faction
If only more games had implemented awesome destruction effects like that…
I remember buying Red Faction on release for $100 (the Australia tax is fantastic) after playing the demo I got on the cover disk of a gaming magazine (years before I had internet access).
I seem to remember it looking spectacular and running surprisingly well on the Pentium 3 / Nvidia Riva TNT2 computer I had back then.
EDIT:
War Thunder had a particularly well-implemented April Fools joke…