If you're looking for gametype mods, I would definitely recommend StrangeLove and Rocket Arena UT. I only played Tactical Ops for a little bit, but you're probably better off with CS 1.6. As for non-gametype mods, look for something called "Crotch Shot". I've always found that to be funny especially what pops up after you kill someone with it.
StrangeLove is basically a redeemer that you can ride on and fly around with. Rocket Arena has maps that are a set of maps. Basically each level has about 5-10 maps and people can switch between the maps to enter different arenas. The arenas vary as it can be 1v1, 2v2, or Team DM (there's usually one of these). You'll start out with max ammo and all weapons I believe (minus the redeemer) as you try to take out your opponent. The winner faces the next person in line and so on. The objective is to try and get the longest streak...or maybe the most points. I remember having loads of fun with this mod...not sure if the final version was 1.60 or later.
As for the others, I have no clue...but it couldn't hurt to try them.
Jam it back in, in the dark.
85242
35212
SuperSonic