Does your friend have a normal sized tower or a small form factor? If his is normal sized, he should be able to get the Hercules 9000 PCI. From what I gather, it's probably the best pci card out right now. A couple of people over at Sudhian forums have it, and it, for them, consistently outperforms the Powercolor 9000 PCI (which is what I have). I just recently purchased the Herc. card and will try doing some benches tomorrow to compare after I get my PCI extension cable. I have a SFF factor Dell, and the Herc. card is freaking huge, so I'm hoping with the cable, I can just go ghetto and hang the extra 2 inches or so out the back.
EDIT: Looks like I didn't answer your original question. Sorry. I've never played BF1942, so I don't have any experience with it and PCI vid cards. The most graphically strenuous game I have played on a PCI card is Dungeon Siege.