This is a list of some of the current dlc weapons, with pro's and cons.
Police pistol- Strong base damage, bonus critical damage, easy to find ammo and easy to repair, and standard holdout weapon. Average spread for a pistol and standard crit rate.
.45 auto pistol- Strong damage, can be silenced and light weight. Large spread and ammo is bought or made only.
A Light Shining in Darkness- Powerful, good crit chance and lightest than any other handgun. Sightly above average spread and same ammo issue as above.

Automatic Rifle- Beastly DPS and DAM for an automatic weapon. Breaks down fast, expensive ammo and pathetically wide spread. (Power is everything option, basically)
.45 auto Submachinegun- Strong, and high rate of fire, sturdy for an automatic weapon. Ammo is an issue, and even modded, it has a wide spread.

That is the first half, the next half will be larger by far.

A Light Shining in Darkness- Powerful and can be a great concealed weapon in casinos
Automatic Rifle-Powerhouse but very inaccurate

ALSiD and .45 Sub. Love those two guns.

A Light Shining in Darkness is one of my top favorite weapons in the game period, so you know where my votes going. Not that big a fan of the 45 smg though, it chews through way too much ammo for my liking, which svcks to because I LOVE shooting that thing, not to mention it looks awesome.

A Light Shining in Darkness is basically a gamebreaker if you specialize in Guns. Not to mention that with Super Handloads you can increase its damage input insanely and then max out crits with Joshua's armor and Finesse.

I like the Automatic Rifle a lot too. The spread is crap, but Steady fixes that. With JSP rounds it can saw through just about anything.

My favorite weapon so far? The Compliance Regulator. Its 10 second paralysis abillty leaves any enemy vulnerable and with a high critical hit chance, its a beast of a weapon (plus it looks damn cool). I usually fire it until I stun an enemy, and then finish off that enemy with a few laser rifle blasts to the head.