Worry about what HW you'll need to play Doom 3 when it comes out. If it's on anyone other than an id employee's hard drive in 12 months I'll eat my Nailgun . id is definitely a "when it's done" company.
Buy a card to run games now. If you're looking to buy a card to run games a year from now whatever you buy today will already be 1 or 2 generations behind.
I think the hacked/overclocked Radeon LE is an excellent suggestion, especially for ~$70. A GF2 GTS 64MB will generally oc to the 200/400 Pro spec, so I wouldn't spend extra for a Pro. Ultras and GF3s are pretty much for benchmarking and bragging right now and don't give you a lot of value, in my opinion. So few games use T&L right now, let alone all the great stuff the GF3 can do.
As for Max Payne, see how you do in 3D Mark 2000/2001. Same engine.