ok people listen up. for anyone with a p3 800mhz like one of u said u had. listen to me! i had the same system specs as you.
900mhz celeron (little diff but not really)
382mb sd ram
30 gig hard drive
32mb tnt2 video card.
what i did was simply buy a g-force 4 64mb ddr ram, with dual 350mhz processors. and guess what? my gameing expiereance cant be ANY better. even soldier of fortune 2 works great on EXTRA HIGH textures. and it cant even support extra high textures on my girlfriends p4 1.7 ghz computer with 256mb sd ram and 32mb g-force 2 3d card.
so if anyone wants a good 3d card. buy a g-force 4 mx 440. thats what i have, and god dam, is it awsome! mohaa doesn't have ANY flaws. with this 3d card. i now run mohaa in all high textures. with resolution at 1000sumthing X 700 something. and its smooth as hell. and this includes real dynamic lighting and full entity lighting. EVERYTHING is on high. i strongly recommend this video card. it also has video out, so u can watch it on your tv, or play games on your tv if you buy the s-video cord. and best of all! the card is only 230 bucks. in canada. so cheaper in the u.s.a!
i hope this helps everyone a bit
regards: Lt.Col.Racer 7th Ranger Battalion