Like Detonics was getting at, red dots on pistols are fantastic for target shooting. Target acquisition is just so much faster than with iron sights. Granted, I don't know that they serve much of a purpose on a handgun otherwise, but they are great for targets.
I have met a few people who use them because of failing eye sight, as well.