Counter-Strike: Source blends Counter-Strike's award-winning teamplay action with the advanced technology of Source technology. Featuring state of the art graphics, all new sounds, and introducing physics, Counter-Strike: Source is a must-have for every action gamer. Game updates since mid 2010 are done by Hidden Path Entertainment.
it does not contain porn nor anything like that.
too violent(no gore), you can be a terrorist in game
some players in multiplayer experice might say strong profanity,
other players might put sprayed walls of porn and everyone can see it,
The two game modes I know of, they pretty much do suck. Hostages / Bomb planting, they do get boring after a while. And, let's face it - they aren't very newbie friendly. Don't get me wrong, they're alright to play from time to time. Anyways...
I'll tell you what I do like about this game. I like the servers that host the Gun Game Deathmatch, and the other servers that host the zombie mods. Both are extremely fun to play, and many servers these two modes tend to vary a lot (Gun Game servers will sometimes have different guns for you for different levels, some require different amount of kills between levels, and a combo of the two of course. Zombie mod servers can have you facing against tons of bots, or will be all human players, and about 20 seconds into the round, one human player is chosen as a zombie.)
Seeing as I haven't been on CS:S for a while now, from the time I'm writing this review, there are a lot of other modded servers to play on, one type of modded servers being RPG.
So, if you haven't - I suggest giving CS:S a try. Sure the vanilla game modes get boring. But try it out for the modded game modes. They definitely will provide hours of entertainment.