Nevakonaza, you are incorrect about other people's pings messing up the server, or the client's pings.
Many times in an FPS people will kick people with high pings because either they can't contribute to the game (like in L4D, where teamwork is needed) or because they are harder to hit (Warrock, if the person is jumping all over the place, it's kinda hard to hit them).
However, someone's ping cannot affect the server you are playing on.
As for the OP; Battlefield 2 is a good game if you like flying and driving around in tanks and truck blowing the bajesus outta people, but the CQC is horrific. It takes about 3 shots to the head with an M4 from point blank to kill someone. Hopefully they'll fix CQC a little more in BF BC2.
I've become very fond of Team Fortress 2 lately, and even though it's not much like CSS (I used to play CSS on an amateur competitive level, and loved it), it still gives me the fun I need. I think the maximum I've seen on a server is around 32 players (16v16) but that seems like a lot on a medium/small map.