If I use a sniper rifle (which is once in a blue moon) the default pistol is more than adequate. If I use an SMG (always), Flare Gun: it's so satisfying to kill someone with it.
So I got a little time in with my lowbie TR alt and finally put my Repeater to use. Wow. Mowed down two heavies in a straight up 1v2 firefight with that thing. Me likey.
https://forums.station.sony.com/ps2/index.php?threads/video-hot-sweaty-and-in-yo-face.139340/ you can see both the underboss and tx2 emperor in action here. TX2 Emperor is by far, the best sidearm that my ability allows me to use. I think it's a very individual choice based on preference.