Quake requires it (although it's pretty unplayable on an 030 in my experience), THX will take advantage of it. Most 3D Raytracing apps will use it (Imagine, Real 3D, Lightwave) and I think some sound software uses it although I can't remember the name.
There are more but that's as much as I can remember right now. :-)