Pistol Primaries in Games

Pistols are weapons that show up in almost every shooter. While they're depicted as secondary weapons most of the times, there are a significant number of games in which you can use a pistol as a primary weapon. How often have pistols been used as primaries in real life? And why is it such a relatively popular trend in games?