Some other peoples opinions .... I guess its what works best for you ...
Me - USP and Unsilenced Colt - but the MP5 is my next fav gun and then the HE Gren is so good - especially as I tend to run around with one in my hand ( Gren that is ) and get shot by some sneaky hidey person, drop the Gren and still kill them and then say "killed from the grave" - some people dont always see the funny side to that ..... anyway some quotes below ....
http://www.counterstrikeuk.co.uk/
The Glock is a very useful weapon for close range combat, because of its poor accuracy and also its burst mode second function. This enables the user to shoot many more rounds while your oponent does not. It is only a 9mm round and does not cause much serious damage, but when aimed at the head it can be a real killer. Use this weapon wisely.
The USP is a very standard handgun. All Counter-Terrorists start with this weapon, and it is most effective at finishing off your targets if you have that window of opportunity. Also, it comes with an optional silencer. When the silencer is on, stealth will become important to you. The silencer decreases your accuracy so it is better not to use it, but if you need to get the jump on your target, then use it!
The H&K USP45 is one of the better pistols in the game. It is the default pistol for the CT side, and is a much more powerful than the T's default Glock. As shown in the bullet-spread shot, the USP maintains a fairly high degree of accuracy at high rates of fire. You can add a silencer to your USP with the secondary fire button. The silencer is nice for shooting unsuspecting enemies at close range, but don't expect to surprise more than one person at a time since it takes quite a few shots to take someone down.
http://firingsquad.gamers.com/games/csweapons/page3.asp
The USP is one of several guns in CS that is affected by range. At close range, one shot to an unarmored head will take off all 100 health. With enough distance between you and the enemy, the same shot will leave him with health in the single digits or thereabout
The Glock 18 is Gooseman's subtle way of telling America's youth that terrorism sucks. The Glock is the worst gun in Counter-Strike. It is the weakest in terms of damage, and it is not very accurate at long range. Although it is fairly accurate at close range, there isn't much incentive to stick with this weapon. In a pistol duel, the Glock's large clip will outlast most other weapons. Sadly, your opponent will likely kill you before you need to reload.
If you are confident in your aim, the Glock's secondary three shot burst fire is really the way to go at close range. Two bursts to the head will usually secure the kill. You may want to stop the enemy with a shot or two in regular semi-auto mode just to create a still target. Then, switch to burst mode and nail the head.
The stopping power of the Glock can really come in handy for your teammates as well. If you really want to make a fellow sniper happy, touch up his target with a couple of semi-auto Glock shots to make him an easy shot. Run over to the corpse and grab his weapon afterwards.