My favorite game mode is the one where you drop an SSG 08 or SCAR-20 to your drunk German teammate so he can unleash his special spells and 'own' the enemy Russian 'smurf' (a closet cheater with a $1 account).

EDIT: After the CS2 update, German wizards no longer have to stop to cast spells, which has significantly improved their efficiency. Additionally, they can now fire rapidly with weapons that normally require reloading after each shot, adding a new level of firepower to their arsenal.