There are only a few good pistols: Fibber, Infinity, and Maggie.
In my own personal experience, SMGs in general are good: I don't HAVE to use an orange or E-Tech for them to be good.
Pistols are some of the best weapons in the game. You can find purple vladof machine pistols that dwarf ANY SMGs or Assault rifles in pretty much every category. As far as ammo goes, Salvador doesn't care.