Try looking for a sniper mod.

I know COD4 had a good sniper (only) mod/server. Custom maps (sometimes too large), and sometimes custom sniper functions such as applying a health pack after surviving a shot.

WaW should have a mod. I know there's a zombie mod (mini game spinoff) for it.