Hey thanks for the thanks, everyone. np at all
It seems i got the directory wrong, but i just tested it, and i haven't, it is the 'main' folder the cfgs need to be in. The problem is COD2 ignores any autoexec.cfg. According to:
http://www.tweakguides.com/COD2_2.html
It says you should put .cfg files in your main/players/<profilename>/ directory. But i found that doesn't work. I tried that first and it ignored the autoexec like the article states, and any other .cfg files you put in your player profile folder. So i copied both cfg files to the main directory, and thought that got it running. It did, but i'd forgotten i also ran "exec autoxec.cfg" manually in the console after copying them too. My bad.
So, to get this working, you do have to put the .cfg files in the \main\ folder. Then you must enable the console, and after setting your video options in the menu, type "exec autoexec.cfg". You don't need to do that everytime you run the game, only after changing any graphics options. exec autoexec.cfg will add it's contents to your config.cfg after your new options are written to config.cfg.
Then the , . / keyboard binds will work, and so the picmip tweak bound to "." will work too. You'll know if tweak.cfg runs because your fps will boost, and the screen will pause for ~1sec each time you press the key.
Toxikneedle:
r_gpusync takes values 0 to 3, enable the console and type r_gpusync and hit Tab, it'll show the option names. I remember 0 is off, 3 is adaptive... 1 is beginning, 2 is beforePresent. I think it's referring to the stage in rendering that the gpu cores are synched maybe? I'd suggest you load up the first USA mission, climb the rope to the top of the cliff, and hit pause when you're looking over the trenches, it's a very busy scene in the game. Then pull down the console, and type r_gpusync 1, then 2, then 3. It updates instantly when you change the option, try 0 to see your fps dive with sli. I expect value 3, adaptive, works best for sli, choosing the most suitable option 1 or 2 depending on the scene.