Also, don't forget: Day of Defeat Source, incase you don't like the quake engine.
Half Life Opposing Force has a nice online multiplayer gamemode named "HL Teamplay", which is a co-op mode online, but ofcourse, Opposing Force's co-op. But the game itself is also very nice

Also Garry's Mod, an "Indie" First Person Shooter, which you might know, it uses the Source engine, props and ragdolls from HL2, CS:S, HL2 EP1, EP2, Lost Coast (Half Life 2 Lost Coast), Portal and Team Fortress 2 AND ALSO HL2 Deathmatch AND Day of Defeat Source AND Half Life Source and also Half Life Deathmatch: Source so you can mess with them or build anything you want. The game also has a nice co-op mode, which you can play HL2 games cooperating with other players

EXTREMELY WORTH IT: 9$ But you need those games to run and use 100% of everything.
Also, you can play on CS:S maps, and invite friends to play and kill everyone on sight, something like CSS:DM game mode

It also has some game modes of... guess what? Roleplay!! Yeah, such as RRPX and DarkRP, Argonath would look extremely well in that :hurray:
Or if you rather go kill some zombie opponents, it has Zombie Survival game mode, VERY nice.
I'd rather buy this to have atleast some inaff content: The Orange Box. Since you hace CS:S you don't have to worry about anything. (Lost Coast is buy as gift)
Trust me, Garry's Mod is one of the best mods ever made in my opinion.
:ps: Don't, but please don't download it. only 7 or 10 cracked servers and like 3 don't work @_X