AFAIK, custom CS weapon models for a 1911 and an M60 exist, among others. But of course, any custom model is always on the same values as the wepon it replaces, and there are no modular aimpoint systems or different crosshairs unfortunately...
It would sure be great to have things like working night vision scopes for CS - that would enhance the tactical element.