What are your sysytem specs? Your price range dictates either one of the older Vodoo3's or a used TNT2 Ultra, though for a little more you could spring for an MX. On my system I play that game at 32 bit, 2xFSAA, 1024x768, gets a little slow sometimes but even then stays payable.
MS CFS2 is a different matter, though I think it is a little buggy, looks a lot better than MS CFS1.