Yea the key to the "team" is to make them get REALLY close to the enemies. At a distance > 5 feet, they just shoot over and over in the general direction of the enemy. They're useful for spotting enemies you can't see, as they just keep shooting at them (without killing them, of course).
When they're forced to be really close to the enemies, like in Mile High Club, they're very effective. In fact, in order to beat it on Veteran (only 60 seconds), you have to leave 2 or 3 for your team to kill, because you simply don't have time to do it yourself.
And yea, Veteran made me scream. The part in One Shot One Kill where you have to defend the Ferris Wheel is so god damned insane on Veteran. There are LITERALLY 120 terrorists, all of which will kill you in 2 to 3 AK bullets. Half of my attempts were spent trying to find some little nook to hide in that was impervious to grenades, because they all seem to have 2 grenades EACH.
EDIT for Ustwo:
Yea, I just kept getting stuck on Bloc.. I think that's the name of it. With the two long apartment buildings facing one another. Every time I came around a fucking corner, it was a P90. Maybe not overpowered in general, but definitely on that map. Have you tried P90 with Sleight of Hand? Holy shit, that's a fast reload.