I found this game very entertaining and there are still plenty of servers online with a variety of official game modes and maps as well as custom made game modes and maps.
Its hard to say how much time you will get out of this game as it is multiplayer only but if you enjoy it and like the use of WW2 weapon and terrain you should be able to get at least 15-20 hours out of it. That being said i really enjoyed this and clocked 60+ hours.
As for the community of players that are still playing this game; not once did i play a game that had someone screaming or typing abuse to anyone on the server, People actually use their mics for tactical direction on this game rather than telling other players how poor they are etc, that being said, i may have just been lucky with the servers that i played on and the times of day.
You will need to work as a team if you have any hope of playing this game without becoming cannon fodder, If you are the type of player that likes to just run in and gun as soon as round starts then this game is going to frustrate you rather quickly as you rapidly build a negative kill to death ratio. So no grabbing an MG and running and gunning the map up, your team will rely on the covering fire so that they can move up without getting slaughtered, especially seeing as most servers limit the number of a class that can be used by one team, people may get a bit miffed if you have the only mg class and you are actively trying to take flags rather that give covering fire.
I defiantely recommend this game to people if they enjoy online multiplayer and and a ww2 period setting.