atm not really, as there isnt a lot ( if any) games that support it to the max
but apparently games like ut2007 ( well, now called ut3) will take advantage of cards like this to make an even more realistic "world" physics, and more destructable buildings ( but each time you strike the building, different sized chunks will fall off, rather than the same generic size lump)
tbh, i think that games would look good with this to start with ( the same as you do with any new game, you crank up all the details) then once you have see it in action, you would turn it back off, because in the pure adrenalin filled deathmatches and stuff, your hardly likely to be able to admire the scenery being demolished!