A small CS server would be okay, but at the risk of alienating some people I'd prefer it to be a no-AWP one. The whole design of the AWP is based around when the best people too used to have to lead their targets (namely the old netcode, which was in use up to Beta 6 [6.5 was the first one under the new]), and it was hence impossible to hit 100% of your shots. In its current build it is absolutely unsuited for public play, where the same map is played over up to half an hour and it is very easy to get the cash for and hard to get the coordination necessary not to get slaughtered by it.
But thats just my 2 cents on Counter-Strike. I used to play a good bit of it back when it wasn't anything remotely resembling a retail product, and enjoyed it for the fast pace and merciless damage system. While its true that a big reason people dislike it is the crowd, that isn't the only reason - it does lack a bit of long-term appeal if you have more than the attention span of a fruitfly, it can easily get super-frustrating and whatnot.
Also, and another addendum to server-specific balance, for the last few years CS has had a monetary system geared more towards clanplay, with top-end weapons going to the winning team of the first round. While it might make sense in competitive matches, it again doesn't in public play - nobody likes to get walked over for the whole 30 minutes of a map in a pub. I'm sure theres some serverside mods out there that would allow for lowering the win/loss cash rewards (hostage, gunfire hit and kills are okay).
Before anyone smartasses, I know the old system was mostly in use when you could still be a gunrunner, but its still more fun without everyone at 16000. :p